Html maker

[blues1449]

Unable to open html maker with error message access to vb project is not trusted. Kindly assist. TQ

 

[schielrn]

In 2003 try:

Click OK to close the dialog box with the error and go to Tools->Macros->Security. Click the Trusted Sources tab and check the box next to "trust access to Visual Basic Project," and click OK.

In Excel 2007, the directions are slightly different:

Click the Office Button and go to Excel Options->Trust Center->Trust Center Settings->Macro Settings->Developer Macro Settings. Then you can Check the "Trust access to the VBA project object model" box and click OK.

This is from this link:

http://www.mrexcel.com/forum/showthread.php?t=89356

Hope that helps.

 

[blues1449]

i already follow the step but when i run the excel, it popup error message microsoft office has encountered a problem and needs to close.. we are sorry for the inconvenience. Tq

 

[schielrn]

so basically you cannot open excel? Or does this only happen when you try to use the html naker?

 

[blues1449]

it only happen when i try to use html maker.

 

[schielrn]

In the VBA screen did you check if there were any missing references? Tools-->References. Do any of them say missing. If not then all I can do is suggest trying Excel Jeannie or Erik.Van.Geit Table-It.

Excel Jeannie I know is at the bottom of Richard's profile:

http://www.mrexcel.com/forum/member.php?u=42170

Table-It is at the bottom of his profile under free add-ins:

http://www.mrexcel.com/forum/member.php?u=25109

Hope that helps some, not sure why the html maker is not working for you.