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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Dave,

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

Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Vba workout if a selection is part of a group? 0
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
International Yes or No 2
How to Select NameRange in VBA? 7
VBA code to insert one worksheet into another 2
VBA to TRIM(CLEAN(All Cells in Used Range)) 1
VBA in Excel to read the VBA Code 1
If Stmt; VBA Code; Reference to Cell Value 3

Back
Top