Macro to password protect a workbook and lock and unlock it with a keystroke command

[justdeepee]

Hi All,

I am not a big excel user and I have never created a macro in excel at all. I don't know if what I want can/should be done as a macro or if there is an easier way. In any event, I need advice and assistance.

I have a workbook that is shared by 8 people. Only me, my boss and one other person should be able to edit it, so I need it password protected so none of the others can change anything. My boss is the type who forgets passwords and he works on the document when I am not around. I think it would be simpler for him to remember a keystroke combo like Ctrl+L to lock and Ctrl+U to unlock. Is there a way to do this without creating a macro or if a macro is needed can I get assistance with creating one. Thanks.

[morbdetro]

If you are going for security then you really shouldn't do anything besides a password because if somebody hits the hotkey by accident they can unlock it. You may as well just protect the worksheet and not assign a password

That being said... something like

Please Login or Register  to view this content.

to protect it and

Please Login or Register  to view this content.

to unprotect it. create 2 separate macros one for unprotect one for protect, change password to whatever you want (leave the quotes", assign desired hotkey and you are good to go.