Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Cell Protection Issue | Excel Worksheet Functions | |||
cell protection | Excel Discussion (Misc queries) | |||
Conditional formating - cell protection | Excel Discussion (Misc queries) |