Weird Worksheet Protection going on

[dfolzenlogen]

I have something weird going on with a spreadsheet that I'm working in and given to me by a co-worker to complete. If I open the spreadsheet, it is not password protected. I am able to change column widths, font color, etc UNTIL I enter data in any cell. Once data is entered in a cell, the spreadsheet becomes "password protected" but no password is actually required. I click on Review ==>Unprotect Sheet and can enter data again in a cell but once data is entered in a cell then the worksheet is "protected" again and I am not able to change column width, format cells or text, etc. In fact, those features are grayed out on the ribbon. Any clues?

Thank you in advance for any help

 

[jmacleary]

Is the workbook macro enabled? If so, maybe there is a change event handler running that protects the sheet.

 

[dfolzenlogen]

Is the workbook macro enabled? If so, maybe there is a change event handler running that protects the sheet.

Yes, it is macro enable. What should I check or change?

 

[jmacleary]

Right-click on the worksheet name tab and select View Code. This opens up the Visual Basic (VBA) editor. If there is a worksheet change event handler, you will see it in the window that opens. I strongly suggest, however, that you speak to your colleague if there is any code there - he must have put it in for a reason.