macro quandry.....??
 

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?

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?

That did the trick! Thanks a ton.!!

Still have no idea what macro it was or what it did (was just a blank
module), but it's gone now and everything else works great. =)

~Dae



"Anne Troy" wrote:

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?