Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can second, third user sign excel file containing macro | Excel Discussion (Misc queries) | |||
how do I email amacro? | Excel Worksheet Functions | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Open an Excel file with a date as today in a macro | Excel Discussion (Misc queries) |