Save generates unprotect sheet dialog box
 

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?

Save generates unprotect sheet dialog box
 

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.

wrote:

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