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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.