kill "enable macros" message

[bcamp1973]

i created a macro in a spreadsheet...then killed it. however, now ever
time i open the spreadsheet i get the message asking whether or not
want to enable macros...how do i get rid of this

 

[Guest]

You also have to delete the module where the macro was located.

 

[bcamp1973]

what is a module?

You also have to delete the module where the macro was located.

 

[Guest]

Hi bcamp1973. If you go to tools - macros - visual basic editor you'll see
the modules in the left hand frame. However, please don't just start
removing modules until someone more familiar with the process responds to
your question. I am unqualified to give VBA advice. Sorry I couldn't be
more helpful.

 

[bcamp1973]

Thanks Michael, that was actually helpful...in my mucking about t
create a macro i created a module (which i then forgot about) but i sa
it in the list and deleted it. No longer an issue...

Thanks!
Brian

 

[Guest]

That's great, bcamp1973.