Teedee Access VBA Teedee 2010
Show/Hide Commandbar
Home Tutorial Code Snippets

Show/Hide Commandbar

Checks whether the named CommandBar is displayed; if displayed the bar is closed, otherwise the bar is displayed.



Code Snippet

Public Function DisplayBar(Barname as String) As Boolean     Dim cmb As CommandBar         Set cmb = CommandBars(Barname)     cmb.Visible = Not cmb.Visible     Set cmb = Nothing End Function