View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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