Forum Helper

[Krayons]

It seems that Richard's MrExcel forum helper add-in does not work with Excel 2016. It returns an error: "Access to the VB project is not trusted". Is there an add-in I can use for this forum that will work with Excel 2016? Thanks.

 

[shg]

File > Options > Trust Center > Trust Center Settings > Macro Settings, tick ~

 

[Krayons]

Thanks. Moving past that error, I'm not actually seeing this anywhere.

Once installed you will notice a new menu called ‘MrExcelHTML’. This appears in the worksheet menu bar for Excel versions 2003 and earlier, or within the ‘Add-Ins’ tab in Excel 2007 and more recent versions.

There's no such "Add-Ins" tab in Excel 2016. There is an "Add-Ins" section within the "Insert" tab, but nothing appears here relating to MrExcelHTML.

Advice?

 

[shg]

You're welcome.

Dunno, don't use it.

 

[Krayons]

Concluded that is broken. Cheers mate.

 

[Peter_SSs]

Concluded that is broken.

It's not "broken" - works perfectly well with my version of excel 2016 so it will be something at your end.

What version are you using? Stand-alone/Office 365?, 32-bit/64-bit?, Windows/Mac?

There's no such "Add-Ins" tab in Excel 2016.

Have you right-clicked the ribbon and chosen 'Customize the Ribbon.." and checked that 'Add-In' is ticked in the 'Main Tabs' section on the right?

 

[RoryA]

If you've only just downloaded the add-in, make sure you have unblocked the file in Explorer. Right-click the .xlam and choose Properties, then unblock it (either a checkbox or button, depending on OS).