Missing Macros from Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
If certain keywords exist, such as Kill or references to the Extensibility
Object model with code that calls such macros, by your anti virus software
and/or if the workbook is received via email and the antivirus software is
activated.
 
I can think of three scenarios:
a) someone manually opened the VBA Project and deleted them
b) a macro was built to delete other macros (I think this can be
done)
c) the macros were actually saved to your Personal.xls workbook, were
thus never actually in the workbook and couldn't have been deleted.
(this option assumes that the macros were recorded and not manually
created).

I'm sure an MVP can confirm these scenarios and add others (should
they exist -- scenarios, not MVPs)...

ray
 
In addition to the macros being deleted, all of the worksheet codenames are
gone. I'm aware that macros can be written to delete modules (I've done it),
but I'm not sure these folks have that ability. It's like the modules are
being stripped out for some reason.

Would saving as 2007 and then opening as 2003 cause this problem? I don't
have 2007 here so can't check.

Thanks,
Barb Reinhardt
 
Just curious: is the file size dramatically different to what it use to be?

Just wondeing if they are hidden some how or completely gone.
There is heaps of macros posted on the web to delete macro's so possibly someone is smarter than the average bear and did a bit of cut and paste.
Unfortuanley pwd protection is next to useless when even macro pwd's can be bypassed in secs.
 
Back
Top