TOOLBARS

[Rob33]

I have this code (below) in a worksheet that puts the print icon & Zoom % on the worksheet menu bar - i want to know what code i need to enter in the "BeforeClose" so these icons disappear when the worksheet is closed

Private Sub Workbook_Open()

Application.CommandBars("Worksheet Menu Bar").Controls.Add Type:= _
msoControlButton, ID:=4, Before:=11
Application.CommandBars("Worksheet Menu Bar").Controls.Add Type:= _
msoControlComboBox, ID:=1733, Before:=12
End Sub


THANKS!!

 

[Tazguy37]

You could do this:

    Application.CommandBars("Standard").Controls(23).Delete
    Application.CommandBars("Standard").Controls(23).Delete

I recorded that, so there's probably a better way. HTH