UI Ribbon: How to unpress a toggle button?

[Kamolga]

Hi,

I try to untoglgle a button after use. My xml code is

[/URL][/IMG]

and I tried this in VBA

Sub TbtnManClick(control As IRibbonControl, Pressed As Boolean)
Dim Manvalue As Variant
Manvalue = InputBox(Range("LgMan"), Range("LgMan"), Range("RngMan"))
Range("RngMan") = Manvalue

[COLOR=#ff0000]'Untoggle the button????[/COLOR]

returnedVal = False
  Pressed = False
End Sub

 
Sub GetPressed(control As IRibbonControl, ByRef returnedVal)
  returnedVal = False
  Pressed = False
End Sub

without success. Any hint?

 

[RoryA]

A toggle button naturally toggles itself. If you don't want that, why use one?

 

[Kamolga]

Because I want a few simple gray ones below one another with a caption: I have words written on the ribbon to click, which in this case is more intuitive than icons. Basically I click "Date" and I have a calendar coming, or "Manager" and have an input box to put his/her name. All those have been set up through userforms at opening of template and the ribbon allow to change specific parts of the form that we could want to update without going through them all again.

But by the way, it would be nice if they were toggled/pressed if the cell where input is made is empty so that we could easily spot the data that requires input. That would be easily set up if I understood how to change this status.