View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Hit Alt+F11, Daesthai. From there, you'll see Project (filename).
Double-click it and each item in the heirarchy below it and look to the
right for code. You may also see "Module X", and you can right-click and hit
Remove (choose NO when asked to export). Just Ctrl+A in any other code
windows at right and hit Delete key.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Daesthai" wrote in message
...
I am working on an excel sheet that is basically a cut and paste job from
some other excel sheets. Somewhere along the line I must've grabbed a

macro
in the cutting and pasting, because now when I open the new sheet, I get

the
macro warning and do I want to enable macros.

So here's the quandry, I know how to delete and edit macros through the
tools/macro menu, but when I go to delete the macro, there is nothing

listed
in the macros file. So how do I track down and find this macro so it can

be
deleted?