Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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


Reply
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
Re-formulating the problem: Dynamic Button Names! Mike Excel Programming 3 February 9th 05 06:24 PM
Add msocontrolbutton to commandbar problem Ricky S Excel Programming 1 January 29th 05 12:08 AM
create commandbar / control button using codes tango Excel Programming 0 October 26th 04 01:38 AM
static commandbar Button Hari Excel Programming 0 June 22nd 04 10:50 AM
Commandbar button running macro Kwan Kim Chuen Excel Programming 0 July 27th 03 11:51 AM


All times are GMT +1. The time now is 06:41 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"