Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am posting this for the second time, didn't get any help so far.
I have a sheet which I can protect by running a protect macro. It checks for formula and hyperlinks in the sheet if so, it locks the cells and then protect it. However, in addition to that I want the user to still be able to sort it or filter it or even format it, without changing the formula or hyperlink(which are locked and protected). The features should be available to the unlocked cells. Can anyone help me with this please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Locking Cells ... Without Protecting Sheet | Excel Discussion (Misc queries) | |||
Protecting a sheet that includes a solver function | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |