View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
 
Posts: 238
Default quick access tool bar show/hide custom button on open/closeworkbo

I use this in the sheet code to call macros that open and close
toolbars.

Private Sub Worksheet_Deactivate()
Call NoBar16
End Sub

Private Sub Worksheet_Activate()
Call Bar16
End Sub