protect cells in excel to prevent users from deleting formulae
TWO STEPS
Format Cells Protection
Tick 'locked' for the cells you want to be protected
untick it for any cells you don't want protected
Then
Tools Protection Protect Sheet
Allow users to select only unlocked cells
Put a password in
--
Allllen
"locking cells in excel" wrote:
how do i protect cells in excel to prevent users from deleting formulae in my
worksheets
|