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?
Bookmarks