Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Setting a reference to the Ribbon

I can get a reference to my customised ribbon and store it in a module
level variable using the following callback:
Public Sub rbxCustomUI_onLoad(ribbon As IRibbonUI)
Set mrbxRibbon = ribbon

However, if my code gets stopped (eg. due to a bug elsewhere) then the
variable holding the pointer to the ribbon goes out of scope. Is
there any other way to set a reference to the ribbon without needing
to close and reopen the workbook?

Thanks a lot,
Andrew
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
Setting Display of Keyboard Shortcuts in MenuBar and/or Ribbon Ray in Jacksonville Setting up and Configuration of Excel 0 October 29th 09 06:21 PM
Setting a cell with a value as a reference for another function Stressless Excel Worksheet Functions 1 October 28th 08 03:01 PM
Setting VBA reference programmatically Nicholas Dreyer Excel Programming 3 October 19th 06 03:49 PM
Setting Reference to another WorkBook-Problem davidm Excel Programming 2 March 13th 06 03:00 AM
Setting up Reference Library using VBA Alan Excel Programming 1 November 5th 03 03:18 AM


All times are GMT +1. The time now is 11:53 AM.

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"