| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for Code in a Workbook
If I open a workbook in a macro, how do I check that workbook to see if it
contains VBA code? -- Bill @ UAMS |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for Code in a Workbook
if you set your security to medium before you open it, it will bring
up the warning that the workbook contains macros, & do you want to enable them? :) susan On Aug 21, 2:29*pm, BillCPA <Bill @ UAMS wrote: If I open a workbook in a macro, how do I check that workbook to see if it contains VBA code? -- Bill @ UAMS |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for Code in a Workbook
Chip Pearson has a function you may be able to use, see Testing If A
VBComponent Exists at: http://www.cpearson.com/excel/vbe.aspx Cliff Edwards |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for Code in a Workbook
This should help you get started
http://www.cpearson.com/excel/vbe.aspx -- HTH, Barb Reinhardt "BillCPA" wrote: If I open a workbook in a macro, how do I check that workbook to see if it contains VBA code? -- Bill @ UAMS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for testing whether a cell or row is highlighted? | Excel Programming | |||
| Checklist for testing code? | Excel Programming | |||
| unit testing code using vba | Excel Programming | |||
| Testing code for oldest version... | Excel Programming | |||
| testing the state of a checkbox in vba code | Excel Programming | |||
Hybrid Mode
