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