excel worksheet "becomes" protected

[Guest]

Hi,
Using excel 2000 various worksheets become protected whilst editing them
i.e. I use & edit for some time then all of a sudden I get locked out & told
the cells are protected. When I go to "Unprotect" it's greyed out as only the
"Protect" option is available.
Please can somebody help it's starting to drive me crazy!
Thanks

 

[Nick Hodge]

If a worksheet 'protects' itself, then there must be some code in the
worksheet_change event or similar or you have an add-in playing up. It's
difficult to direct you to delete the event code if it is there for a
reason, (e.g when you enter something once in a certain cell it protects
it), but you can right click on each sheet tab and/or the icon at the top
left of the workbook and select 'view code...'. If there is code in the
resulting window, this may be the issue. (Deleting it will render it non
functional)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

Thanks Nick, I've tried this & there isn't any code on these
workbooks/sheets. These are very simple spreadsheets with date calculating
formulas in them - the error occurs when I've been using the spreadsheets for
a while (entering data/formatting the non formula cells) & then these same
cells (& all the otherones) are suddenly protected & therefore "uneditable".
Any other ideas? Thanks

 

[Nick Hodge]

No other ideas, sorry. It sounds like it is multiple workbooks. If you
would like to send me one I could take a look, but it may not happen on my
machine

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[krTaylor]

Spontaneous protection - unwanted!

This is happening to a worksheet of mine too. I have been unable to figure out why. There is no protection code, but there is vb code that puts the date into the worksheet for each row of data entered.