Thread: macro to create toolbar on open and clear it on close
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
incjourn[_7_] incjourn[_7_] is offline
external usenet poster
  
Posts: 1
Default macro to create toolbar on open and clear it on close

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

Reply With QuoteReply With Quote