'Save As' warning 'Protected and therefore read only'

J

jerrygolfer

Something happened to my workbook when I e-mailed the file to another site. When I try to 'Save As', a warning pops up saying"The cell or chart you are trying to change is protected and therefore read only". I then click the "OK" 11 times and it lets me "save As". My older versions of the workbook do not do this. Thx for your help. Jerry
 
B

bdcrisp

do you have this workbook posted on a site available for download? its
hard to diagnose this problem without seeing the code
 
D

Dave Peterson

It sounds like there might be an event macro lurking that's causing you trouble.

Try opening your workbook with macros disabled. The try to save it and see what
happens.

Excel's VBA has a workbook_beforesave event that can try to update a cell (or 11
cells) before you save the workbook.

You may want to go back to the developer and ask them to look at your
workbook--if it isn't you.

Did you change versions of excel (like from xl97 or xl2k to xl2002)? Maybe the
code expected something that it didn't find in that other version.
 
T

teresa

I want to copy to a disk.Keeps saying i can't read only. I change it in explorer but not happening
 
Top