I've successfully adapted this to my needs and can get the key that is pressed.
Issues I am having are...
1. "consume" what you mean Willis? The Release and Press booleans don't seem to keep the program from trying to use the key pressed. This is a locked (protected) sheet and it still comes up with a message that the sheet cannot be edited after the macros that need ran get ran.
EDIT: fixed this one... I wasn't setting both of them at the same time. 2.I'm also trying to adapt the double click sort macros you kids whipped up into this to determine the row that is selected when I press a key. The box border is highlighted but not filled in blue like when you drag a selection.
- Code: Select all Expand viewCollapse view
'get the current selection
oCell = oDoc.getCurrentSelection().getCellAddress()
'get the clicked location
iRowSelect = oCell.Row
iColSelect = oCell.Column
But I get an error on
oCell = oDoc.getCurrentSelection().getCellAddress().
Not sure where to go from here. If I could get those 2 issues to work for me I can get the rest of the deletion macro written.
I'm just looking to completely lock down the program so that the people I work with cannot possibly mangle it and forcing then to delete through a macro keeps things nice and clean (hopefully).