On 2002-04-23 00:22, Peter100 wrote:
Thanks although I'm a little hesitant about not being able to turn them back on again.
I'm not quite sure how to implement the bars I want switched off. where and how Do I list these ie. before the EndSub ?
could you be so kind as to show me the procedure for say turning off the "standard" Toolbar
Then turning it back on before closing the workbook
Private Sub Workbook_Activate()
CommandBars("Standard").Visible = False
End Sub
Private Sub Workbook_Deactivate()
CommandBars("Standard").Visible = True
End Sub
TomPrivate Sub Workbook_Activate()
Application.CommandBars("Standard").Visible = False
End Sub
Private Sub Workbook_Deactivate()
Application.CommandBars("Standard").Visible = True
End Sub