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

[Goodstart14]

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

[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.

[FDibbins]

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

[Goodstart14]

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

[FDibbins]

I also made macros but it protected right away.

Not sure I understand? if you unprotect the WS, it will not just re-protect itself

[Goodstart14]

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?

[FDibbins]

upload a sample please

[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.

[Goodstart14]

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?

[strongmen1969]

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

[FDibbins]

hmm well if you have VBA applying your protection, then unprotecting manually will have no affect. Thats a small detail that you should have shared upfront

[coreytroy]

Please Login or Register  to view this content.

[Goodstart14]

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.

[Goodstart14]

Please Login or Register  to view this content.

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