Excel Macro Woes

[Bluto]

I'm using Excel 2000 on an NT platform and wrote a macro to perform a menial task. Not being skilled at macros I found that what I had written wasn't what I wanted, so I deleted it. I did so in the usual way....tools/macro/macros/delete. Fine and dandy right?.....wrong!

Whenever I open that spreadsheet I get an annoying window that pops up prompting me to disable or enable the macro. Well...the macro was deleted, and I cannot find a trace of it anywhere. So if I enable or disable nothing happens.....the macro won't run because it's not there. What I DO want to disable is that cotton-pickin' pop-up message!

How can I find where either all the macros are kept, or find this one particular macro so I can eliminate it and get rid of the annoying window?

Anyone have any ideas please?

Thank you - -

Bluto: confused;

 

[RayH]

With your spreadsheet open, hit Alt-F11 to bring up the VB window.
In the left frame expand the VBAProject for your workbook and expand Modules, right click on any existing modules and select Remove.
Save your workbook.

 

[Bluto]

Ray.....

Amazing!....that was it! I never would have found that one! I looked quite a bit thru the help, but it only pointed to those places that I knew to check already. I'm not versed in VB either tho.

I appreciate your help.....thanks!

bluto