-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Unprotect all sheets run macros Protect sheets
- Thread starter sean1541
- Start date
PeteWright
Active Member
- Joined
- Dec 20, 2020
- Messages
- 421
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi @sean1541
The problem you will face is that protected sheets cannot handle macros.
One possible solution would be to insert a code that unprotects the sheets before running the macro and protects them again after macro was run.
The downside of this is that you'll expose your password in the VBA code.
I found an interesting post that you may want to read an another post that sounds promising.
The problem you will face is that protected sheets cannot handle macros.
One possible solution would be to insert a code that unprotects the sheets before running the macro and protects them again after macro was run.
The downside of this is that you'll expose your password in the VBA code.
I found an interesting post that you may want to read an another post that sounds promising.
Upvote
0
