Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enable autorepublish warning message (using static web page)? | Excel Discussion (Misc queries) | |||
disable 'enable macros' pop-up message on all computers | Excel Discussion (Misc queries) | |||
Disable/Enable Macros Message box in Excel2007 | Excel Discussion (Misc queries) | |||
how to get around the Enable Macro security message? | Excel Discussion (Misc queries) | |||
Bypassing ENABLE/DISABLE MACROS message | Excel Discussion (Misc queries) |