Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Ribbon toggle button issues

I have two custom toggle buttons on the ribbon and they work sometimes but it
is very clunky. When I first open the file the ribbon works.

But it seems sometimes if I switch to another file and/or do some other
tasks, then go to use either toggle, I get "Object variable or with block
variable not set". If I close and reopen the ribbon file again it works again
--- for awhile.

The error is on this line: gRibbonUI1.InvalidateControl ("rxTB1")

I think the variable gRibbonUI1 which is set to "ribbon" is falling out of
scope (gRibbonUI1 is declared at module level as a Public variable). But, if
this is the case, then any code requiring invalidation of the ribbon is
unstable and basically useless...unless of course my code is goofed up, which
is highly possible.

Can anyone help me through this issue?

Thanks!
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
Toggle Button William Excel Programming 4 November 5th 08 05:51 PM
QAT Buttons and Ribbon Issues in Excel 2007 Ailish Excel Discussion (Misc queries) 1 May 9th 08 06:02 PM
Toggle Button in Ribbon to Hide/Show Built-in Tabs Don[_30_] Excel Programming 0 March 27th 08 12:17 PM
[Office 2007] Auto-hide ribbon toggle button and control recent do Yishion Excel Programming 2 June 4th 07 08:27 PM
Adding .xla button for Toggle Calculation Button Mike Excel Programming 5 August 19th 05 01:55 PM


All times are GMT +1. The time now is 01:23 AM.

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

About Us

"It's about Microsoft Excel"