Disable/Enable macros when there aren't any! [RESOLVED]

lost_chord · May 9th, 2002, 06:31 PM

I am using Excel 2000 (9.0.3821 SR-1) on Win 2000 (5.0.2195 SP2 Bld2195).

If I have a spreadsheet for which I have defined macros then I get the Disable/Enable warning message when I open it.

Fair enough.

However, if I then delete all the macros and save the spreadsheet then when I open it I continue to get the Disable/Enable warning message.

Why is it so and what can I do about it?

Many thanks,
LC

[ This Message was edited by: lost_chord on 2002-05-09 18:46 ]

Tom Schreiner · May 9th, 2002, 06:46 PM

Make sure you have removed all of your standard modules. Even if they are blank, you will get the security prompt. Macros are Public procedures. Make sure you do not have any Private procedures as well.
Tom

lost_chord · May 9th, 2002, 07:30 PM

Thanks Tom but I don't understand what you mean by "standard modules". I have deleted every macro in the workbook that I know about. When I look at Tools | Macro | Macros I get an empty listbox subtitled "Macros in: All Open Workbooks". I can select "Macros in: This Workbook" but of course that is also empty.

Where can I see these "standard modules" and how can I remove them please?

Thanks,
LC.

James · May 9th, 2002, 07:35 PM

What Tom wanted you to do was Alt-F11> Microsoft Excell Objects>Sheets>Forms and Modules delete all code AND even empty modules

James

_________________

[ This Message was edited by: James on 2002-05-09 18:37 ]

mikeyboy · May 9th, 2002, 07:40 PM

You need to go into visusal basic editor. Tools - Macro - visual basic editor and delete all the modules if any. The modules will be in the left pane window. Simply by existing these modules will produce the security message when opening excel.

While you are in the left pane double click on each sheet and "ThisWorkbook" and delete any code you find.

[ This Message was edited by: mikeyboy on 2002-05-09 18:40 ]

lost_chord · May 9th, 2002, 07:46 PM

Thank you, Tom, James and Mikey.

Problem solved.

LC

[ This Message was edited by: lost_chord on 2002-05-09 18:48 ]

msohail · Jan 10th, 2003, 07:41 AM

Hi,
I have encountered the same problem as per this email, however when I've followed the solution i.e Tools_Macro_Visual basic Editor the page is totally blank!!!!! What else can I do to get totally rid of this annoying enable/disable message plz??

msohail · Jan 10th, 2003, 08:50 AM

I am having the same problem as per this email below. I have tried Tools_Visual Basci .. but the page is totally blank and no hint of any macro code! Can I do anything else to get rid of the annoying enable/disable message??

Jaafar Tribak · Jan 10th, 2003, 09:00 AM

Hi MsoHail,

TOOLS-->MACRO-->VISUAL BASIC EDITOR-->VIEW-->PROJECT EXPLORER.
This should display all the VB projects.
Expand the the little boxes on the left to locate the modules you want to remove.

Jaafar.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 06:31 PM	#1
lost_chord New Member Join Date: May 2002 Posts: 3	I am using Excel 2000 (9.0.3821 SR-1) on Win 2000 (5.0.2195 SP2 Bld2195). If I have a spreadsheet for which I have defined macros then I get the Disable/Enable warning message when I open it. Fair enough. However, if I then delete all the macros and save the spreadsheet then when I open it I continue to get the Disable/Enable warning message. Why is it so and what can I do about it? Many thanks, LC [ This Message was edited by: lost_chord on 2002-05-09 18:46 ]

May 9th, 2002, 06:46 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Make sure you have removed all of your standard modules. Even if they are blank, you will get the security prompt. Macros are Public procedures. Make sure you do not have any Private procedures as well. Tom

May 9th, 2002, 07:30 PM	#3
lost_chord New Member Join Date: May 2002 Posts: 3	Thanks Tom but I don't understand what you mean by "standard modules". I have deleted every macro in the workbook that I know about. When I look at Tools \| Macro \| Macros I get an empty listbox subtitled "Macros in: All Open Workbooks". I can select "Macros in: This Workbook" but of course that is also empty. Where can I see these "standard modules" and how can I remove them please? Thanks, LC.

May 9th, 2002, 07:35 PM	#4
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	What Tom wanted you to do was Alt-F11> Microsoft Excell Objects>Sheets>Forms and Modules delete all code AND even empty modules James _________________ [ This Message was edited by: James on 2002-05-09 18:37 ]

May 9th, 2002, 07:40 PM	#5
mikeyboy Board Regular Join Date: Apr 2002 Posts: 57	You need to go into visusal basic editor. Tools - Macro - visual basic editor and delete all the modules if any. The modules will be in the left pane window. Simply by existing these modules will produce the security message when opening excel. While you are in the left pane double click on each sheet and "ThisWorkbook" and delete any code you find. [ This Message was edited by: mikeyboy on 2002-05-09 18:40 ]

May 9th, 2002, 07:46 PM	#6
lost_chord New Member Join Date: May 2002 Posts: 3	Thank you, Tom, James and Mikey. Problem solved. LC [ This Message was edited by: lost_chord on 2002-05-09 18:48 ]

Jan 10th, 2003, 07:41 AM	#7
msohail Board Regular Join Date: Oct 2002 Posts: 120	Hi, I have encountered the same problem as per this email, however when I've followed the solution i.e Tools_Macro_Visual basic Editor the page is totally blank!!!!! What else can I do to get totally rid of this annoying enable/disable message plz??

Jan 10th, 2003, 08:50 AM	#8
msohail Board Regular Join Date: Oct 2002 Posts: 120	I am having the same problem as per this email below. I have tried Tools_Visual Basci .. but the page is totally blank and no hint of any macro code! Can I do anything else to get rid of the annoying enable/disable message??

Jan 10th, 2003, 09:00 AM	#9
Jaafar Tribak Board Regular Join Date: Dec 2002 Location: Larache--Morocco Posts: 4,570	Hi MsoHail, TOOLS-->MACRO-->VISUAL BASIC EDITOR-->VIEW-->PROJECT EXPLORER. This should display all the VB projects. Expand the the little boxes on the left to locate the modules you want to remove. Jaafar.