Display commandbar as add-in

Recently I have been having problems with commandbars in all spreadsheets.

I downloaded the add a menu spreadsheet from royUK's website and when I open it I get...

Please Login or Register  to view this content.

...and on debug the line in red

I guess the red does not show up...the first line after Do

Please Login or Register  to view this content.

This file has opened fine in the past, but as of late I get this error. When I close the spreadsheet I get the run time error 91 again.

Also, try to open Richard Schollar's HTML maker and I get...

Please Login or Register  to view this content.

...and on debug the line in red

I guess the red does not show up...the first line after On Error

Please Login or Register  to view this content.

I have other spreadsheets which use commandbars and I get errors. I've tried to narrow it down and can get the commandbar to show up by adjusting certain aspects of the code, but it seems the problem is coming for the removing of the commandbar on close.

Any thoughts?

It could be something to do with using Excel 2007. Commandbars & Menus are not supported in Excel 2007 onwards, they have been replaced by the Ribbon

Hi Roy,

Why do you think these have worked for quite a while now or my 2007 and then just suddenly began throwing up errors?

Some vbCrLF's seem to be missing (before Loop and before IF)

Please Login or Register  to view this content.

Hi snb,

Not sure there is anything wrong with the code as it works perfectly fine on another 2007 machine.

On the website there is a note:

Please Login or Register  to view this content.

Do you know where I can find an example of using a menu through the ribbon?

If the line is red it means it's a compile error. The reason is what I formulated in my previous post. Please read that again and insert a vbcrLF in the lines that are marked red. Do not look where it can't be found.

I think you have copied the code & somehow deleted the line breaks. try

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

End Sub