Enable Macro message

U

ub

I had few macro in my sheet.
Now I have deleted all the macro's in my sheet
But still I get the message box to Enable or Disable macro when I open my
sheet.
Please advise, you till message can be disabled, when I have no macro in my
sheet
 
P

Peo Sjoblom

You need to delete the module as well, press Alt + F11 to open the VBE, look
in the project pane to the left, right click it and select remove module and
answer no when prompted to export it

--


Regards,


Peo Sjoblom
 
U

ub

Thanks a lot, It works

Peo Sjoblom said:
You need to delete the module as well, press Alt + F11 to open the VBE, look
in the project pane to the left, right click it and select remove module and
answer no when prompted to export it

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top