Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detecting Calc On or Off | Excel Discussion (Misc queries) | |||
Detecting Duplicate Sums - Worksheet code | Excel Discussion (Misc queries) | |||
Detecting Numbers in a cell | Excel Worksheet Functions | |||
Detecting absentees | Excel Discussion (Misc queries) | |||
Detecting a color | Excel Worksheet Functions |