PDA

View Full Version : Hide "track changes" option



nedy_03
09-22-2007, 05:10 PM
hello,

I have a protected worksheet, but the "track changes" option from "tools" menu is still available! Is it any way to hide it ? ,...


thx,
nedy

Bob Phillips
09-23-2007, 01:30 AM
Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Controls("Track Changes").Enabled = False

nedy_03
09-23-2007, 04:25 AM
Where should I put this ?

Bob Phillips
09-23-2007, 05:30 AM
How/when/where do you want to turn that facility off?

nedy_03
09-23-2007, 06:21 AM
Whrn i want to see the "Track changes report"

Bob Phillips
09-23-2007, 06:33 AM
Oh the old 'when you want it' event. Sorry, but there is no such event within Windows/Office.

nedy_03
09-25-2007, 03:07 AM
ok thk ...