hello

i have created a toolbar menu, but i would like it to appear on opening the
workbook and disappear on closing the workbook.

any suggestions?


thanks

mike

Try something like this under the worksheet object?

Private Sub Workbook_Open()

Application.CommandBars("Picture").Visible = True

End Su

--
incjour

-----------------------------------------------------------------------
incjourn's Profile: http://www.excelforum.com/member.php...nfo&userid=721
View this thread: http://www.excelforum.com/showthread.php?threadid=49514

mike wrote:
hello

i have created a toolbar menu, but i would like it to appear on opening the
workbook and disappear on closing the workbook.

any suggestions?


thanks

mike
Mike

Try two auto macros in a module


Sub Auto_Open()

Application.CommandBars("Special").Visible = True

End Sub


Sub Auto_Close()

Application.CommandBars("Special").Visible = False

End Sub

"Special" refers to your customised toolbar.

Hugo