Macro "Ghosts"

M

Michael Mulvaney

I created a workbook while another was open. The "other"
had macros, the new did not. However, now Excel thinks
there are macros and high-security user cannot open the
file! (The list of macros for this file is empty...)
Thanks!
Michael
 
P

Paul B

Michael, You also have to remove the modules on which the macros were stored
have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
J

Jim

You also have to delete the Modules which formerly held the macro(s).
Alt+F11 to open the VB Editor and remove unused modules you find in the
workbook.
 
Top