Save generates unprotect sheet dialog box

[cwhankey]

Recently one of the Excel workbooks I use started requesting a
password to "unprotect" every protected sheet when I enter data and
try and save the workbook. I DID NOT change any protected regions.
I've used the spreadsheet many times and never received a password
dialog before. I can cancel out of each dialog that appears and still
save the spreadsheet, but this is very annoying. Any ideas?

 

[Dave Peterson]

It sounds like you have an event macro that's firing when you're saving the
workbook.

If this is a workbook that you developed, look in the ThisWorkbook module
(first).

If this is a workbook that was developed by another person, I'd go to that
person with a complaint.