Ghost Macro (s)

M

me

There is a macro in this one file but I can't find it. Is there a mapping
feature for macros that will allow me to hunt it down and delete it?
 
D

Debra Dalgleish

The information is Windows based.
The mac in the URL is short for macros, not Macintosh.
 
M

me

hmmm, can you can imagine me with my thumb and index finger in an "L" on my
forehead.

haha
 
M

me

damnit jim!

i followed the steps but i still get the enable/disable prompt when i open
the file.
what i did notice, when i was deleting code from the individual sheets, if i
opened the sheet code again the code was still there even though i just
finished deleting it.

userform and modules are gone.

there is code to remove all vbe...where/how do i use that?
http://www.cpearson.com/excel/vbe.htm
 
T

Texas Aggie

i don't know if it will help or not but i can send screenshots of what i'm
doing...or trying to do. email me a jrhughson at st-joseph dot org
 
E

Earl Kiosterud

Me,

How about the sheet and ThisWorkbook modules? Step 7 of Debra's page. If
you have another workbook open, make sure you're removing stuff from the
correct workbook while your'e in the VBE.
 
T

Texas Aggie

Earl-

did that. i followed every step on that sheet and it was the only workbook
open but i couldn't get the evil out of it.
instead of wasting time trying to figure out where i was making errors, i
just opened the file, disabled macros, and moved all 8 million sheets to a
new book and saved it. opens clean now which is wierd but i'm not going to
look a gift-horse in the mouth.

thanks ya'll, for your help.
 
Top