Enable/Disbale Macro on opening Excel file

[Guest]

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?

 

[Nick Hodge]

Fred

Check here

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk