Save generates unprotect sheet dialog box

  • Thread starter Thread starter cwhankey
  • Start date Start date
C

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?
 
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.
 
Back
Top