ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dynamic commandbar button problem (https://www.excelbanter.com/excel-programming/338286-dynamic-commandbar-button-problem.html)

JB2005

Dynamic commandbar button problem
 
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



Vic Eldridge[_3_]

Dynamic commandbar button problem
 
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



JB2005

Dynamic commandbar button problem
 
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




All times are GMT +1. The time now is 01:36 PM.

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