Need to get the IRibbonUI object back after VBA error termination

A

Andrew B

In Office 2007, if VBA terminates following an error or End statement, any
IRibbonUI object saved from an onLoad event is lost, and currently the only
way to recover it is to close and reopen the workbook. A method of recovering
this object directly in VBA would be helpful.
--
Andrew B

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8754&dg=microsoft.public.office.developer.vba
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRibbonUI should work as an Object in VBA 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
"The operation cannot be performed because the object has been deleted." 0
OneNote "Dock to Desktop" should hide like the Tablet Input Panel 0
use vba to create new code module in access 2007 0
Word 2007 VBA Help documentation inconsistency 2
Why not having South Africa (Rand value) on your list? 0
4" long side panel box allowing the viewing of minimized items 0

Top