brothertruffle880
asked on
Excel VBA - Removing worksheet passwords from a group in one workbook
I have a workbook with an ever-changing number of worksheets (between 2 and 8). Each worksheet has its own password and as soon I open the workbook up, I'd like to be prompted to unprotect each of the sheets.
Can someone help me code this?
Can someone help me code this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Every sheet has a different password, or they are just protected?
ASKER
Each sheet has its own password. The Jan sheet has password "January", The feb sheet has "february", etc.
ASKER
Thank you Martin. Works perfectly.
You're welcome and I'm glad I was able to help.
Marty - MVP 2009 to 2013
Marty - MVP 2009 to 2013