How can i unprotect a workbook and sheets that already protected?

Hi,
I have a workbook that is protected by password.
Everytime I fix some problems, I have to unprotect sheets.
This is really annoying.
How can I unprotect sheets and workbooks while I am updating or changing?

Thanks

Hi Goodstart14,
Since you have a password, open the workbook unprotect it and save it.
Reopen the work book it will be in unprotect mode by now.

Originally Posted by strongmen1969

Hi Goodstart14,
Since you have a password, open the workbook unprotect it and save it.
Reopen the work book it will be in unprotect mode by now.

Thanks.
I did what you said and this workbook is unprotected.
How about worksheets?
I unprotect sheet1 then save it and reopen, but it didn't work.

record a macro doing the unprotecting the sheets 1 by 1, then record another macro protecting each 1. Then run them when needed

I also made macros but it protected right away.

What should I do?

Thanks

When I unprotect by password, the Sheet is unprotected , then when I click any cell in the Sheet, all tabs are gray out.
For example:
I have to click Review tab again to unprotect, and then go to Home tab to change font, then all tabs are gray out again. I have to click Review tab again,,,,,,,,
How can I solve this problem?

Hi, If i not wrong the ws may has a VBA written, if you think you don't need it maybe you can delete it, and do remember VBA will gone forever.

Originally Posted by strongmen1969

Hi, If i not wrong the ws may has a VBA written, if you think you don't need it maybe you can delete it, and do remember VBA will gone forever.

Yes, my worksheets have VBA, that's why I protected.
Do I have to comment out every password in my VBA?

maybe you need to upload a sample so that we can more clearly what you means.

Please Login or Register  to view this content.

Originally Posted by FDibbins

Thats a small detail that you should have shared upfront

I am so sorry.,I didn't explain well, but I learned. Thank you for your patient.

Originally Posted by coreytroy

Please Login or Register  to view this content.

Thanks,
Sorry, butI am beginner inVBA. How can I use this?
Thanks in advance.