Macros are disabled?? What Macros?

FredMFoley · Mar 24th, 2002, 01:12 AM

Every time I open some of my workbooks (in Excel 2002) I get the message:
"Macros in this workbook are disabled because the security level is high etc."
I don't think there are any macros.
None appear when I look in ToolsMacroMacros...
I would prefer to keep the security level high, and don't know how to stop this message, other than tediously copying and pasting all my data to a new workbook.
(EditLinks... is greyed out)
Can you tell me what have I done, and/or how to fix it?
Thank You

Dave Hawley · Mar 24th, 2002, 01:23 AM

Hi

You must delete the empty Modules as well. Open the VBE then right click on the modules and select "Remove Module 1" etc.

FredMFoley · Mar 24th, 2002, 01:36 AM

Thanks a lot Dave.
I,ve done that and it fixed the problem.
I didn't knowingly create any macros. I may have 'played' with the recorder a long time ago. Would this be the reason those modules were there?

Ivan F Moala · Mar 24th, 2002, 01:50 AM

Quote:

On 2002-03-24 00:36, FredMFoley wrote:
Thanks a lot Dave.
I,ve done that and it fixed the problem.
I didn't knowingly create any macros. I may have 'played' with the recorder a long time ago. Would this be the reason those modules were there?

Fred...this was probably the reason for the modules being there.

Ivan

adey · Nov 24th, 2005, 03:27 AM

I wondred if you had a asolution to my macro security problem here?

http://www.mrexcel.com/board2/viewto...light=security

I'm really under the cosh with this one because we need the worksheet macros working to produce some work.

Any ideas?

Nov 24th, 2005, 03:27 AM	#5
adey New Member Join Date: Nov 2005 Posts: 3	Hello Dave I wondred if you had a asolution to my macro security problem here? http://www.mrexcel.com/board2/viewto...light=security I'm really under the cosh with this one because we need the worksheet macros working to produce some work. Any ideas?

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

Mar 24th, 2002, 01:12 AM	#1
FredMFoley Board Regular Join Date: Mar 2002 Location: Tasmania Posts: 58	Every time I open some of my workbooks (in Excel 2002) I get the message: "Macros in this workbook are disabled because the security level is high etc." I don't think there are any macros. None appear when I look in ToolsMacroMacros... I would prefer to keep the security level high, and don't know how to stop this message, other than tediously copying and pasting all my data to a new workbook. (EditLinks... is greyed out) Can you tell me what have I done, and/or how to fix it? Thank You

Mar 24th, 2002, 01:23 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi You must delete the empty Modules as well. Open the VBE then right click on the modules and select "Remove Module 1" etc.

Mar 24th, 2002, 01:36 AM	#3
FredMFoley Board Regular Join Date: Mar 2002 Location: Tasmania Posts: 58	Thanks a lot Dave. I,ve done that and it fixed the problem. I didn't knowingly create any macros. I may have 'played' with the recorder a long time ago. Would this be the reason those modules were there?