Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trace dependents in protected sheet
I have a worksheet where I would like the users to be able to use Trace
Dependents. However, when I protect the worksheet this is no longer possible. So I was was wondering whether it is possible to create a macro which allow you to use Trace Dependents when a worksheet is protected? Thanks Ken |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trace dependents in protected sheet
You would have to include in your code a temporary removal of the sheet
protection, with password and unprotect statements. Then reinstate the protection after you do the precedent test. Pretty tricky setup. "Ken" wrote: I have a worksheet where I would like the users to be able to use Trace Dependents. However, when I protect the worksheet this is no longer possible. So I was was wondering whether it is possible to create a macro which allow you to use Trace Dependents when a worksheet is protected? Thanks Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trace dependents | Excel Worksheet Functions | |||
Trace Dependents | Excel Discussion (Misc queries) | |||
trace dependents | Excel Worksheet Functions | |||
Trace Dependents | Excel Programming | |||
Trace dependents | Excel Programming |