Code below successfully remove specific Toolbar in a worksheet but do not work in a chart sheet? How can I?
[vba]
Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Delete
Application.CommandBars("Worksheet Menu Bar").Controls("Format").Delete
[/vba]
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
[vba]
With Application.CommandBars(2)
.Controls("Tools").Enabled = False
.Controls("Format").Enabled = False
End With
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
