just added colo's html maker and im getting an error

[j4ymf]

hello the html maker works great but evertime i start excel i get this error

Error Number :=91
Error Discrp := Object Variable or with block variable not set

you may have to manually set the reference to the [VBIDE = VBE6EXT>OLB]

what do i do to manually set the reference

thanks jason

 

[Von Pookie]

Read the FAQ (link in my sig below).

 

[j4ymf]

thankyou von pookie

silly of me not to read all the error messeges,
that worked fine

thanks jason


for others you need to do this:

Error: "Error Number: 91, Object Variable or with Block variable not set..."
Click OK to get rid of the dialog box and go to the Tools->Macros->Security. Click the Trusted Sources tab and check the box next to "trust access to Visual Basic Project," and click OK.