CommandBarButton State

I

ianc

I have been trying to change the state of a button so it toggles from a
pressed down state (msoButtonDown) and Up State (msoButtonUp).

However, everytime I try and set the state as below I get an error message.
Can do same thing in Excel with no such problem.

anyone any clues how to make a button toggle, or fix this code?

many thanks,

//ian

'-----------------
' Test code below
'
Dim Btn As Office.CommandBarButton

Set CmdBar = Application.CommandBars("Test")
Set Btn = CmdBar.Controls("Button A")

If Btn.State = msoButtonUp Then
Btn.State = msoButtonDown ' *** ERROR HERE ***
Else
Btn.State = msoButtonUp ' *** and ERROR HERE ***
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get Control.State to work 15
Change CommandBarButton state not working 0
Problem setting the State of a custom Toolbar button 4
Custom commandbar (1 works, 1 doesn't) 6
How to stop prompt to save changes to add-in 0
word 2003 add-in : CommandBarButton.State 1
Determine if Selection is Text (Application Event Procedure) 2
Columns(i).Hidden not changing 4

Top