I have a exel file which always asks me whether I want to disable macro
during start up. I don't need any macro in it at all and I checked from menu
Tool->Macro->Macros. But there is nothing in the list. How can I find it and
delete it please?
I have a exel file which always asks me whether I want to disable macro
during start up. I don't need any macro in it at all and I checked from menu
Tool->Macro->Macros. But there is nothing in the list. How can I find it and
delete it please?
The message has an 'Always Ask' option.
Untick this to suppress the message
JL
You could take a look here...
http://www.nickhodge.co.uk/tipstrick...warningremoval
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
"JL" <jlmagzine@hotmail.com> wrote in message
news:eUNl8$JQFHA.1168@TK2MSFTNGP10.phx.gbl...
>I have a exel file which always asks me whether I want to disable macro
>during start up. I don't need any macro in it at all and I checked from
>menu Tool->Macro->Macros. But there is nothing in the list. How can I find
>it and delete it please?
>
Hi JL
Go into you VBA editor (ALT F11) and see if there are any modules in
there. If there are, delete them.
Regards
Karen
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks