I have gotten a couple of questions emailed to me directly on how to hide
all open toolbars and then to display them back the way they were. Here is
some sample code that will demonstrate this:
Dim MyTbs() As String
Sub CloseToolbars()
ReDim MyTbs(0) As String
Dim tb As Toolbar
For Each tb In Toolbars
If tb.Visible = True Then
tb.Visible = False
ReDim Preserve MyTbs(UBound(MyTbs) + 1) As String
MyTbs(UBound(MyTbs)) = tb.Name
End If
Next tb
End Sub
Sub ResetToolbars()
For i = 1 To UBound(MyTbs)
Toolbars(MyTbs(i)).Visible = True
Next i
End Sub
If you have any questions, let me know.