Thu 23 Apr 2009, 16:34Delegate Daren said...
Daren has attended:
Excel VBA Intro Intermediate course
Visual Basic
I have used a Excel sheet that when opened put's a drop down menu automatically on the Task Bar.
How is this don.
Sun 26 Apr 2009, 21:58Trainer Carlos said...
RE: Visual Basic
Hi Daren
Sorry for the delay.
I'm not sure what you mean about the drop down menu. Does it appear next to the other menu options or is it a command bar.
The way you make a command bar or any other item appear when a particular worksheet opens is
1. In the code window create the Workbook's Open event as shown below:
Private Sub Workbook_Open()
Application.CommandBars("TheCommandBarName").Visible = True
End Sub
To hide the command bar do the same in the close event.
Hope this helps
Carlos
