------ Register to get rid of these "In Post" ads! ------


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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/111326-custom-toolbar.html#post398849
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.

------ Register to get rid of these "In Post" ads! ------


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



"Luciano Severino" <LucianoSeverino@discussions.microsoft.com> wrote in message
news:9E3865A1-0C32-4690-9FC6-28E36F680DB8@microsoft.com...
>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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/111326-custom-toolbar.html#post399031
> the "MyToolBar" doesn´t apearence.
> Anybody know why it´s happen?
> Thanks.
>

------ Register to get rid of these "In Post" ads! ------


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

--

Gary Keramidas
Excel 2003


"Luciano Severino" <LucianoSeverino@discussions.microsoft.com> wrote in
message news:9E3865A1-0C32-4690-9FC6-28E36F680DB8@microsoft.com...
>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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/111326-custom-toolbar.html#post399035
> 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.
>