ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Enable Macro message (https://www.excelbanter.com/excel-worksheet-functions/198106-enable-macro-message.html)

UB

Enable Macro message
 
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

Peo Sjoblom[_2_]

Enable Macro message
 
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

"ub" wrote in message
...
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




UB

Enable Macro message
 
Thanks a lot, It works

"Peo Sjoblom" wrote:

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

"ub" wrote in message
...
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






All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com