 Back to jkp-ads.com |
Ron de Bruin
|
 |
|
Back to jkp-ads.com |
Ron de Bruin
|
|
Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.
Luckily, Ron was kind enough to allow me to publish all of his Excel content here.
Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.
Kind regards
Jan Karel Pieterse
There is a common problem when you are working with the Ribbon with
RibbonX and VBA. The ribbon object (which is initialized when Excel loads
your file) can loose its reference to the ribbon, which means your code can
no longer tell Excel to update your ribbon customizations. There is simply
no easy built-in way to recover the handle to the Ribbon when there are
problems in or with your code. The only way to fix it is to close reopen
your workbook, not a very user friendly way.
But MVP
Rory Archibald came up with a great idea in a
post in the MrExcel forum. The example in the workbook that you can
download on this page is based on Rory's idea and works in Excel 2007 32 bit
and Excel 2010 and higher (32 and 64 bit). Idea: Store the pointer to the IRibbonUI in a
cell (or Name or wherever) then use CopyMemory to get it back when the state
is lost.
You can use this example workbook to test this method to
recover the Ribbon handle if it is lost. Download:
Loss of Ribbon
state.zip
Important : The OnLoad ‘called name’ needs to be truly unique, if you have problems check this out first.
Note : Check out also the pages on the site of MVP Tushar Mehta about this common problem
Save a global variable in an Excel workbook
Protect a global variable in another VB project