Macro "Ghosts"

  • Thread starter Thread starter Michael Mulvaney
  • Start date Start date
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
 
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 **
 
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.
 
Back
Top