Detecting VBA code
 

Thanks for the suggestion on Chip Pearson's website.
I've managed to write the code to detect VBA contained
within sheets. However before it can run it requires that
I make a change to the references section contained in the
tools dropdown of the VBE. Chip discusses this.

Anybody know how to do this as part of the code so that
people who run my tool can have this change done
automatically..??

Chris

Detecting VBA code
 

Actually, you don't

Instead of making your declaration like:

Dim VBComp As VBComponent

make it like
Dim VBComp As Object

Do this for any objects in the Visual Basic Extensions library.

--
Regards,
Tom Ogilvy

Chris Gorham wrote in message
...
Thanks for the suggestion on Chip Pearson's website.
I've managed to write the code to detect VBA contained
within sheets. However before it can run it requires that
I make a change to the references section contained in the
tools dropdown of the VBE. Chip discusses this.

Anybody know how to do this as part of the code so that
people who run my tool can have this change done
automatically..??

Chris