Mr Excel HTML maker missing from ribbon

[markgordonis]

Hi
I’ve been trying to install Mr Excel HTML maker. I’m using Excel 2007. If I click on the Excel Office Button, then Excel Options, then Add-ins, VBHTMLmaker.xla is displayed as an active application add-in. However it doesn’t appear anywhere in the ribbon – can someone please tell me why?
Thanks!

 

[RoryA]

I think it goes onto the addins tab.

 

[markgordonis]

Hi Rory

Thanks for your post. I quite agree - the Add-Ins tab was where I was expecting to see it, but it wasn't there. I've also checked all the other tabs.

I'm not sure where to go from here - is there any other application I can use that is not an add-in?

By the way, when I open Excel there is a notification which reads "Access to VB Project is not trusted". When I make the HTML maker add-in inactive this notification does not appear. I'm thinking the solution might be something to do with security/trust settings, but I'm not sure what settings to alter.

I'm not sure if I've put the add-in the right location - I've put it in C:\Program Files\Microsoft Office\Office 12\Library\Analysis\ (which is where my Analysis Tool Pack is).

Thanks
Mark

 

[RoryA]

In the trust center you need to enable access to the VBProject. I suspect that is your problem.

 

[markgordonis]

Hi Rory

In the Trust Center I've ticked "Trust Access to VBA project object model" and this now means that the notification mentioned above does not appear. However still no sign of the HTML maker on the ribbon - any ideas?

Thanks
Mark

 

[RoryA]

is it listed in the disabled addins section?

 

[Firefly2012]

Did you download the right file? VBHTMLmaker.xla is not the MrExcel html maker (you want the zip file on the Skydrive account that I downloaded from whch was entitled "HtmlMaker20101230").

 

[markgordonis]

Thank you Rory and Firefly! I had indeed downloaded the wrong file. Problem now resolved.