custom toolbar

[Luciano Severino]

I had made those procedures same next exemples:

Private Sub Workbook_Open()
Application.CommandBars("MyToolBar").Visible = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("MyToolBar").Visible = False
End Sub


It´s running well. But when I save my workbook to another PC with Excell2007
the "MyToolBar" doesn´t apearence.
Anybody know why it´s happen?
Thanks.

 

[Bernie Deitrick]

Luciano,

Excel 2007 doesn't use toolbars anymore.

See the section

Excel 2007 Ribbon and QAT pages

http://www.rondebruin.nl/tips.htm


HTH,
Bernie
MS Excel MVP

 

[Gary Keramidas]

see if there is add-ins menu option and look there.