ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Workbook_Open does not work (https://www.excelbanter.com/excel-programming/395583-workbook_open-does-not-work.html)

Woodsman

Workbook_Open does not work
 
I have this code in Workbook:

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

After opening the workbook Custom1 toolbar does not apear. I have to turn it
on manually from the View Menu.

What do I have to do to make it work?
Thanks

Gary''s Student

Workbook_Open does not work
 
Make sure you put the macro in the Workbook code area, not a standard module.
--
Gary''s Student - gsnu200737


"Woodsman" wrote:

I have this code in Workbook:

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

After opening the workbook Custom1 toolbar does not apear. I have to turn it
on manually from the View Menu.

What do I have to do to make it work?
Thanks



All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com