Help with Active X Controls in a Dashboard

[Walter D]

Hi:
I would like to use an Active X Control in the banner of my dashboard. The control is a toggle button to allow the users of the dashboard to toggle the toolbar on and off.
I see how to insert and name the Active X Control. I don't know how to make it function as an on and off switch for the toolbar. I have uploaded an example of my dashboard banner and the toggle button.
Thanks in advance - Walter

 

[Chihiro]

Not sure what exactly you mean by toolbar (is it the ribbon menu at top?). But take a look at the codes in the link. You can assign it to Commandbutton1_Click event.

Be sure to read through the entire article.

http://www.ozgrid.com/VBA/toolbar-remove-restore.htm