Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I was wondering if there is a quick or easy way of checking whether a file has any code or macros attached to it? thanks for your help in advance, regards, Youssef |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Youssef,
The easiest way would be to set your security level to Medium Tools/Macro/Security If there's code, you'll be prompted to enable it. If not, the workbook will just open up without the prompt. That's not to say that there couldn't be an empty module in the workbook with no code as that would give the prompt too. John Youssef Mourra wrote: Hi everyone, I was wondering if there is a quick or easy way of checking whether a file has any code or macros attached to it? thanks for your help in advance, regards, Youssef |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checking for the existence of a worksheet | Excel Discussion (Misc queries) | |||
evnet code, checking for entry | Excel Worksheet Functions | |||
Checking and Unchecking CheckBoxes in code | Excel Discussion (Misc queries) | |||
Checking for the existence of a characted in a string | Excel Discussion (Misc queries) | |||
Color Code Date Checking | Excel Worksheet Functions |