Page 1 of 1
Any Excel gurus out there?
Posted:
Mon Mar 30, 2009 4:07 pmby Dutchy
How do I protect a cell in a spreadsheet (I have a formula that I dont want tampered with) I know how to protect the whole spreadsheet but I dont want to do that I just want one cell protected
Any help please?
Re: Any Excel gurus out there?
Posted:
Mon Mar 30, 2009 4:29 pmby grant j
Go to format cells and select protection.
that should do it
Re: Any Excel gurus out there?
Posted:
Mon Mar 30, 2009 4:33 pmby smac
You will then need to enable sheet protection for that to work.
An alternative would be to put the formula in a selectionchange macro that would add that formula to that cell anytime someone changed that cell. Sounds difficult, but it isn't. PM if you want a hand.
Re: Any Excel gurus out there?
Posted:
Mon Mar 30, 2009 7:24 pmby Dutchy
Thanks Gents all done
