Thread: Cell Protection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SusanM
 
Posts: n/a
Default Cell Protection

I have a worksheet with five columns that contain IF formulas (Group A)
linked back to other columns in the same worksheet (Group B). I need to
protect the formulas in those five columns (Group A), so that they cannot be
deleted/changed. I have followed the correct procedures to lock the specific
cells and password-protect the worksheet.

One of the columns in €śunlocked€ť Group B contains links to two other files.
The users need the ability to change the links to other file sources. When
the columns in Group A are locked and protected, the user cannot change the
file links.

Is there anyway around this restriction?