Enable/Disbale Macro on opening Excel file
 

I have an Excel file containing 13 worksheets that contained one macro - the
macro has been deleted but on opening the file I am still told that the file
contains macros and I have to respond by selecting "Disable Macros" or
"Enable macros". Using the Macro command under Tools menu I have verified
that no macros exist in any of the worksheets in the file. Is there any way
to persuade Excel that all macros in this file have been deleted, so that I
no longer see the macro message?

Enable/Disbale Macro on opening Excel file
 

Fred

Check here

http://www.nickhodge.co.uk/tipstrick.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Fred C" wrote in message
...
I have an Excel file containing 13 worksheets that contained one macro -
the
macro has been deleted but on opening the file I am still told that the
file
contains macros and I have to respond by selecting "Disable Macros" or
"Enable macros". Using the Macro command under Tools menu I have verified
that no macros exist in any of the worksheets in the file. Is there any
way
to persuade Excel that all macros in this file have been deleted, so that
I
no longer see the macro message?