Why does Excel unprotect all my sheets when I hit save?

[lpyrrm]

I have protected several sheets in an Excel workbook and in each case have
set a password without which users shouldn't be able to unprotect. But when
I try to save the file, Excel for some reason comes up with a prompt asking
me to enter a password to "Unprotect Sheet". Whatever I do at this point
(either enter a password or click cancel), the workbook will save and the
worksheet will still be protected but it's no longer password-protected,
which I really need it to be! Any help on fixing this would be much
appreciated.

 

[Dave Peterson]

It sounds like you have a "helpful" macro jumping in where it doesn't belong.

I'd try opening that workbook with macros disabled to see if the save worked
normally.

If it did, then contact the developer to find out why he or she did that.

If you were the developer, look for a workbook_beforesave procedure in the
ThisWorkbook module inside the VBE (at least start there).