VBA code to say Yes or No if any VBA code is present in ActiveWork

D

Dennis

Using XL 2003 & 97

Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.

I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .

I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.

TIA Dennis
 
D

David McRitchie

There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
 
D

Dennis

Dave,

I did not think about the reason you gave. Thanks for yout time and
knowledge.

Dennis

David McRitchie said:
There is no bootstrap macro to tell you whether you have macros
or not. If there were there would be no limit to virus writers.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Dennis said:
Using XL 2003 & 97

Would like hit Ctrl+Shift+V and have an answer either yes or no as to the
presence of Any VBA code in the Active Workbook.

I do know that about the VBA editor/Explorer or to press the Run Macro
button and get a list from various sources .

I would like to stay at the keyboard and process a series of macros
including one to let me know if I even need to evoke the VBA explorer.

TIA Dennis
Click to expand...
Click to expand...
 
Top