R
rraw75
In a protected worksheet I have been unable to trace precedent, so I have found some VBA code that achieves this for me. I have put the code in and it does trace precedents on a protected sheet by double clicking on the cell with the link. However the instructions say that there should be a temporary command bar that appears and it does not, can you help? On this temporary command bar should be an icon that can be pressed to trace precedents.
Also I would like to know how I can add this to all my workbooks so that when I send them to my colleagues overseas they can then trace precedents in protected workbooks.
Can somebody please tell me where I may be going wrong? Many thanks
I tried going though this FRee Excel VBA manual I downloaded from mousettrainingdotcom but it doesn't seem to provide me any answers! Any help will be highly appreciated!
Cheers
Amit
Also I would like to know how I can add this to all my workbooks so that when I send them to my colleagues overseas they can then trace precedents in protected workbooks.
Can somebody please tell me where I may be going wrong? Many thanks
I tried going though this FRee Excel VBA manual I downloaded from mousettrainingdotcom but it doesn't seem to provide me any answers! Any help will be highly appreciated!
Cheers
Amit