PDA

View Full Version : Solved: Shortcut to run macro



tkaplan
03-31-2011, 08:05 AM
When I click on Macros and select the macro I want to run and click on options to put a keyboard shortcut on the macro, if I lock the project, the keyboard shortcut no longer runs.
I want to password protect my vba code, but I still want to have a keyboard shortcut to run the macro. How can I do this?

Rob342
03-31-2011, 11:23 AM
You can password protect the vba code and still leave the macro visible or hide the macro's & run the code from a command button
can you post an example workbook ?

nepotist
03-31-2011, 11:42 AM
I dont know what is the problem at your end, But my (Short cut key for the macros Ctrl+Shift+Q) works fine even when the VBA code is locked

tkaplan
03-31-2011, 01:29 PM
nevermind. it's working now. I don't know why it wasn't working before.