Protection Issues

  • Thread starter Thread starter Paul Prichard
  • Start date Start date
P

Paul Prichard

I have a worksheet that is modified on a daily basis. I
am constantly adding rows to entoer more data into this
document. Well, the problem is I have the document set
up to sum the row or column and they are protected from
being changed, but with the whole worksheet protected I
can no longer add any rows to my document. Any help?
 
See if this helps

Select whole sheet go to Formatcels/Protection and uncheck
Locked. Now select the cells you have formulae in and
those you dont want anyone to modify. Go to format
cells/protection and now check Locked. Now go and protect
your sheet. You will able to modify cells which were not
locked.
 
Back
Top