View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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