Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UB UB is offline
external usenet poster
 
Posts: 120
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UB UB is offline
external usenet poster
 
Posts: 120
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enable autorepublish warning message (using static web page)? M Excel Discussion (Misc queries) 2 November 23rd 10 01:44 AM
disable 'enable macros' pop-up message on all computers Adam Excel Discussion (Misc queries) 5 April 19th 08 05:54 PM
Disable/Enable Macros Message box in Excel2007 Vignesh Excel Discussion (Misc queries) 0 February 6th 08 09:00 AM
how to get around the Enable Macro security message? cfman Excel Discussion (Misc queries) 5 March 4th 07 03:59 PM
Bypassing ENABLE/DISABLE MACROS message Excel4u Excel Discussion (Misc queries) 1 December 7th 05 04:05 PM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"