Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Checking for existence of macros or code in an Excel Spreadsheet

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default Checking for existence of macros or code in an Excel Spreadsheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checking for the existence of a worksheet Allen Excel Discussion (Misc queries) 1 January 20th 10 06:57 PM
evnet code, checking for entry Tami Excel Worksheet Functions 3 December 19th 09 04:59 PM
Checking and Unchecking CheckBoxes in code Ayo Excel Discussion (Misc queries) 0 April 3rd 09 08:41 PM
Checking for the existence of a characted in a string Peter Rooney Excel Discussion (Misc queries) 2 June 21st 06 10:16 AM
Color Code Date Checking drvortex Excel Worksheet Functions 3 February 1st 06 07:34 AM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"