Excel macro doesn't run after saving and reopening the file

[JackBauer]

Hello, I have inserted simple macro code into Module1 in excel workbook:

Please Login or Register  to view this content.

It worked perfectly, but then I saved workbook (as xlsm). Once I have reopened a workbook - hitting F4 key is doing nothing.
And code is still there in the module1. It should insert current dateTime to the active cell.
Macros are enabled.

This is my first macro ever, maybe I did something wrong?

[romperstomper]

Did you run the ShortcutDateAndTime routine after reopening the workbook to set the OnKey assignment again?

[CK76]

Please Login or Register  to view this content.

This code should be in ThisWorkbook module, in Workbook_Open() event. This will ensure that you don't have to manually run ShortcutDateAndTime() sub.
EDIT: This binds F4 to "DateAndTime" sub.

Please Login or Register  to view this content.

Now, you may want to reset/disable Application.OnKey before you close the workbook...
To unassign it... you'd use Application.OnKey "{F4}" without the argument for sub to run on key.
Ex:

Please Login or Register  to view this content.

Personally, I'd just use Macro options to assign key combo. Rather than use Application.OnKey.

[JackBauer]

Wow, thank you, will try.

Well this will be used to log work events and elderly people who are not savvy with computers in general, will use that, so I must avoid any key combinations.