ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I 'toggle' a toolbar button (https://www.excelbanter.com/excel-programming/443127-can-i-toggle-toolbar-button.html)

Michelle

Can I 'toggle' a toolbar button
 
Still using v.2003, how can I make a button that I put on my toolbar have
two states like the 'bold', 'italic' or 'drawing-toolbar' buttons?
these buttons appear 'illuminated' or 'depressed' when switched

I hope that makes sense

M



Bob Phillips[_4_]

Can I 'toggle' a toolbar button
 
Application.CommandBars("MyToolbar").Controls("MyB utton").State =
msoButtonDown

--

HTH

Bob

"Michelle" wrote in message
...
Still using v.2003, how can I make a button that I put on my toolbar have
two states like the 'bold', 'italic' or 'drawing-toolbar' buttons?
these buttons appear 'illuminated' or 'depressed' when switched

I hope that makes sense

M






All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com