Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protects running from VBA, but not from hot key
Macro protects workbook as its last command. It works when I run the macro from VBA. But when I run the same macro from a hot key, it runs without error but the workbook is not protected. I'm stumped. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protects running from VBA, but not from hot key
Please post your code and maybe we can help.
-- HTH, Barb Reinhardt "Andyjim" wrote: Macro protects workbook as its last command. It works when I run the macro from VBA. But when I run the same macro from a hot key, it runs without error but the workbook is not protected. I'm stumped. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protects running from VBA, but not from hot key
Any chance that you open another workbook in your macro?
And does your hotkey include the shift key? If yes to both, then remove the shift key from the hot key. If you open a workbook with the shift key held down, then excel thinks you don't want to run the auto_open or workbook_open procedures. And since your shortcut key includes the shift key, it's confusing excel and excel thinks you want to stop. Andyjim wrote: Macro protects workbook as its last command. It works when I run the macro from VBA. But when I run the same macro from a hot key, it runs without error but the workbook is not protected. I'm stumped. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you allow users to copy & paste protects cells | Excel Worksheet Functions | |||
password protects different worksheets n upload on the web | Excel Worksheet Functions | |||
Macro that password protects a sheet | Excel Discussion (Misc queries) | |||
How to prompt user to set password that protects their worksheet? | Excel Programming | |||
Protecting a book protects too much?! | Excel Programming |