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