I'd like to protect a worksheet but allow the users to use the Trace Precedents / Trace Dependents tools to illustrate how the calculation works. Is this possible, using either the checkbox options that appear when you click Review > Protect Sheet, or using macros with additional arguments to ActiveSheet.Protect ? Or some other way
Similar (old, unanswered) thread: http://www.excelforum.com/excel-gene...protected.html
You have to unprotect the sheet to access Trace Dependents/Precedents. No other go...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for responding, Sixthsense. Sad to hear, but I'm glad to know I should stop searching for a way!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks