Excel VBA Ribbon code not working in 2013

[john robinson]

I have some software which opens a template workbook. This book has several sheets and each sheet has a different ribbon arrangement. When the sheet changes from one to another, it invalidates the ribbon and forces it to rebuild, using callbacks linked to the particular sheet, giving us the correct ribbon for that sheet. The software will open several of these template books at a time. Up to Excel 2010 this works fine but in 2013, one book is fine but if I open a second the first book stops changing the ribbon. It appears that the RibbonUI object is no longer set so it won't rebuild.
When loaded it sets the ribbon bu tI can't reset it when the book is open.
Sub ribb******ed(ribbon As IRibbonUI)
ThisWorkbook.ribbonUI = ribbon
End Sub

Has anyone come across this or got a fix for it.
Most grateful for any pointers.
John

 

[RoryA]

You appear to be missing a Set statement there unless this is not VBA.

 

[john robinson]

You appear to be missing a Set statement there unless this is not VBA.

I tried adding a set as suggested and I agree seemed sense but it errored out!
Sub ribb******ed(ribbon As IRibbonUI)
set ThisWorkbook.ribbonUI = ribbon
End Sub
John

 

[RoryA]

What is the declaration of ribbonUI in the ThisWorkbook module?

 

[john robinson]

Public myribbon As IRibbonUI
Works great in 2007 and 2010. I'm wondering if it is to do with the changes in the way Excel windows/frames work in 2013.
John

 

[RoryA]

What's the error message when you use Set?

 

[john robinson]

Error 91 Object Variable or with block variable not set.
John

 

[RoryA]

That's odd. Can you put a sample workbook somewhere (Dropbox / Onedrive / other sharing site) for testing?

 

[john robinson]

The problem is that the workbook is created from a template by the main programme workbook and is heavily referenced to that. So it won't work as standalone. I think I need to try and make a standalone version and see how that works. When done I will be happy to share if I get the same problem. Most grateful for your interest.
John