Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Visual Basic
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Visual Basic
Resolved · Low Priority · Version 2003
Reply 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.
For upcoming training course dates see: Pricing & availability
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
Sun 3 May 2009: Automatically marked as resolved.
|