LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default RibbonX ToggleButton Pressed State

Is it possible to change the state of a toggleButton on Ribbon at run
time?

I use a custom toggleButton which is always visible to show/hide
another custom Tab on the ribbon. Only authorized users should access
this tab, so the button actually calls a userform requesting a
password. There is no problem when switching from On to Off (hide
tab). But when switching from Off to On (show tab), there are two
cases with a problem:
1. When wrong password is entered.
2. Cancel button is clicked.
I have no problem keeping the custom tab hidden in these 2 cases,
however the button has already changed to On.
In this situation, can I change the pressed state back to Off, or do I
have to tell users that this is 'by design' and to click the button
twice.

Thanks
Dovy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
replace state names with state code abbreviations se7098 Excel Worksheet Functions 3 July 25th 09 06:41 PM
Togglebutton ranswrt Excel Programming 4 July 23rd 08 11:29 PM
Togglebutton ranswrt Excel Programming 0 July 23rd 08 10:27 PM
How can I show state-by-state data (as silos) on a map of NA Rob Charts and Charting in Excel 0 November 5th 07 03:41 PM
Converting State Names to State Abbreviations aznate Excel Discussion (Misc queries) 1 October 20th 06 06:52 AM


All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"