Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
I have a workbook that is used by several end-user with sheets that are password protected so they can't overwrite formulas. I have a button which runs a macro that I recorded that unprotects the sheet, performs several other operations, and then protects the sheet again.
The problem is, that when the macro is run by the end-user, it stops and a drop-down box asks for the password to be entered to unprotect. Obviously, it would be defeating the purpose to give the users the password.
My question is: is there any code I can insert in the macro to automatically enter my password in the box to unprotect, and once again, enter it twice to re-protect?
Thanx in advanx.
The problem is, that when the macro is run by the end-user, it stops and a drop-down box asks for the password to be entered to unprotect. Obviously, it would be defeating the purpose to give the users the password.
My question is: is there any code I can insert in the macro to automatically enter my password in the box to unprotect, and once again, enter it twice to re-protect?
Thanx in advanx.