Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unprotecting Sheets

Status
Not open for further replies.

xsubzeroz

Technical User
Oct 15, 2002
39
CA
I have 50 files saved under one folder and each file has password protected sheets. I was wondering if there is any way to unprotect all those files without going into each file and unprotecting worksheets individually. Thanks.
 
This could be done w/ a VBA macro
do you have mutliples files protected?
or do you have files w/ multiple protected sheets?
same passwords?
I think we could figure this out, if you want give me a holler. Tranpkp
************************************
- Let me know if this helped/worked!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top