PDA

View Full Version : Remove Tool Bar in Chart Sheet



jammer6_9
01-14-2009, 02:40 AM
Code below successfully remove specific Toolbar in a worksheet but do not work in a chart sheet? How can I? :help


Application.CommandBars("Worksheet Menu Bar").Controls("Tools").Delete
Application.CommandBars("Worksheet Menu Bar").Controls("Format").Delete

Bob Phillips
01-14-2009, 03:06 AM
With Application.CommandBars(2)
.Controls("Tools").Enabled = False
.Controls("Format").Enabled = False
End With