Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Team,
We have dynamic commandbar buttons - where Caption, State and Action are reset using sub Workbook_SheetActivate routine. Works fine, so long as commandbar remains floating, but when docked, the visual effects (dimming of disabled buttons, etc.) is no longer effective - almost as if its outside a "refresh zone". Focusing on the buttons corrects visual effect. Any ideas/solutions in overcoming this feature? Regards |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A workaround for a similar issue is described here,
http://groups.google.com.au/group/mi...d466975e7748a/ Regards, Vic Eldridge "JB2005" wrote: Hi Team, We have dynamic commandbar buttons - where Caption, State and Action are reset using sub Workbook_SheetActivate routine. Works fine, so long as commandbar remains floating, but when docked, the visual effects (dimming of disabled buttons, etc.) is no longer effective - almost as if its outside a "refresh zone". Focusing on the buttons corrects visual effect. Any ideas/solutions in overcoming this feature? Regards |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for the insight - didn't solve my particular issue, but I later found
it to be an issue with the PC. ;) "Vic Eldridge" wrote: A workaround for a similar issue is described here, http://groups.google.com.au/group/mi...d466975e7748a/ Regards, Vic Eldridge "JB2005" wrote: Hi Team, We have dynamic commandbar buttons - where Caption, State and Action are reset using sub Workbook_SheetActivate routine. Works fine, so long as commandbar remains floating, but when docked, the visual effects (dimming of disabled buttons, etc.) is no longer effective - almost as if its outside a "refresh zone". Focusing on the buttons corrects visual effect. Any ideas/solutions in overcoming this feature? Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Re-formulating the problem: Dynamic Button Names! | Excel Programming | |||
Add msocontrolbutton to commandbar problem | Excel Programming | |||
create commandbar / control button using codes | Excel Programming | |||
static commandbar Button | Excel Programming | |||
Commandbar button running macro | Excel Programming |