Two tasks I am attempting to achieve in a macros-enabled spreadsheet:
1. Enter a simple "X" in a yellow box via key stroke. (currently, must double-click to enter "x"; keyboard is disabled when the yellow box is highlighted in this spreadsheet)
2. Use keyboard shortcut to autofill date after I click on a cell in the spreadsheet, when a popup window prompt appears after I click on the cell, asking me to enter the date. (currently, after the cell is clicked and the popup window appears, user must type date in format "mm/dd/yy"; control semi-colon does not work)
Remedial question, however the obvious answers ("hit the x on the keyboard" and "control semi-colon" fail) do not work.
If there is more info required, please ask, and I'll elaborate.
Best,
Michael
Bookmarks