• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Macro Woes

B

Bluto

Senior member
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;
 
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.
 
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top