Sub ToggleAllToolbars() For Each cb In CommandBars If cb.Type = msoBarTypeNormal Then cb.Visible = Not cb.Visible End If Next cbEnd Sub