ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Showing Toolbar Buttons as Pressed... (https://www.excelbanter.com/excel-programming/354061-showing-toolbar-buttons-pressed.html)

Conan Kelly

Showing Toolbar Buttons as Pressed...
 
Hello All,

Can I get a button on a toolbar to be shown as pressed in Excel?

I've asked before in an Outlook NG and got it to work in Outlook, but
I've forgotten since then (I'll have to wait til I get home to see how
I've done it). I've looked through all of the properties and methods
for the CommandBarButton Objects, but nothing is jumping out at me
reminding me how to do it.

Any help on this matter will be greatly appreciated,

Conan Kelly



Jim Thomlinson[_5_]

Showing Toolbar Buttons as Pressed...
 
The stardard button has a State property of msoButtonUp or msoButtonDown. I
think that is what you are looking for.
--
HTH...

Jim Thomlinson


"Conan Kelly" wrote:

Hello All,

Can I get a button on a toolbar to be shown as pressed in Excel?

I've asked before in an Outlook NG and got it to work in Outlook, but
I've forgotten since then (I'll have to wait til I get home to see how
I've done it). I've looked through all of the properties and methods
for the CommandBarButton Objects, but nothing is jumping out at me
reminding me how to do it.

Any help on this matter will be greatly appreciated,

Conan Kelly





All times are GMT +1. The time now is 01:11 AM.

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