I have an Excel financial form that I copy and rename each time I need fill
it out for a new client. I am now finding that random cells are protecting
themselves and if I go in and unprotect the cell and then realize I need to
change the number - even though I was just typing in the cell, I have to go
back and unprotect it again to make a change. It now takes me twice as long
to fill out this form and update the form because some of the cells keep
protecting themselves. Does anyone know how I can correct this?
--
JAG

This occurs on one worksheet only in the workbook?

I would guess you have some event code that runs when you enter something in
a cell.

Right-click on the sheet tab and "View Code".

Anything in there like Worksheet_Change code?

If so, remove it or Comment it out by placing an apostrophe at the beginning
od each line.

Or selecct it all and on Edit Toolbar hit the "Comment Block" Icon



Gord Dibben MS Excel MVP



On Fri, 6 Feb 2009 12:39:00 -0800, Julie G
wrote:

I have an Excel financial form that I copy and rename each time I need fill
it out for a new client. I am now finding that random cells are protecting
themselves and if I go in and unprotect the cell and then realize I need to
change the number - even though I was just typing in the cell, I have to go
back and unprotect it again to make a change. It now takes me twice as long
to fill out this form and update the form because some of the cells keep
protecting themselves. Does anyone know how I can correct this?