Deleting a macro

[ootsoo]

hi all,

A small issue in xl.

i created an xl file a.xls. in process of updating the same i created a macro Mac1.But as that macro was no necessary i deleted the macro. so now no macro exists in a.xls. but still if i open the file it pops up a message whether to enable or disable the macro.

is there any way to prevent the message from poping up?

regards,

ooTsoo

[ereborn]

A bit old topic but maybe you didn't solve your problem.

Try to run Visual Basic Editor (ALT+F11)

On the left side you can see two windows with PROJECT and WORKSHEET properties

In the upper one (PROJECT) you can find

Microsoft Excel Objects and Modules

Open MODULES and there is list of all macros you made.

If only one there is your Macro ...

Rightclick at Module1 (name of macro) and Remove module

Dialog will appear with question to save or export deleting module.

If you don't need it simple remove the module.

Save and try to open.