VBHTML Maker install problems

[Kenneth 5]

Windows Seven Professional
Excel 2007
I have been trying to use VBHTML Maker,but Excel keeps giving me the message.(Access to the VB project is not trusted)

The VBHTML Maker.xla file is placed in C:\ Microsoft Office\ Office12\ Library\.

Excel sees the file as an add-in, but then the message appears in a pop-up window, and that's as far as I can go.
The file is located in a trusted area.


I keep getting the following message (Access to the VB project is not trusted)

Looking forward to someone's answer.

Thanks in advance.

 

[Smitty]

You need to allow the VB PRoject.

In 2003 go to Tools-->Macro-->Security-->Trusted Publishers-->Check Trust access to the Visual Basic Project.

For 2007+ it's in Office/File button-->Options-->Trust Center-->Trust Center Settings-->Macro Settings-->Trust access to the VB Project...

HTH,

 

[Kenneth 5]

Thanks Smitty:,

I knew I wasn't thinking straight. But like I said I wasn't thinking straight. Ha ha.

I kept going to the right area, but not quite far enough.

Thanks, we all need a helping hand once in a while.

Have a nice day.