Re: Macro Warning, But No Macros!
From: Bill Kuunders (bill.kuunders_at_xtra.co.nz)
Date: 01/18/05
- Next message: dj.jimmi_at_gmail.com: "Change Number to Actual Text"
- Previous message: GF: "Excel webquery questions"
- In reply to: John Schneider: "Macro Warning, But No Macros!"
- Next in thread: Paul B: "Re: Macro Warning, But No Macros!"
- Reply: Paul B: "Re: Macro Warning, But No Macros!"
- Reply: John Schneider: "Re: Macro Warning, But No Macros!"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 08:38:03 +1300
More than likely this workbook has one or more empty modules in the visual
basic editor (alt+f11).
You need to delete them.
Bill K
"John Schneider" <JohnDONTSPAMME.Schneider@eWebITNOSPAM.Kom> wrote in
message news:OknSK1Y$EHA.612@TK2MSFTNGP09.phx.gbl...
> Running Excel 2003 SP1 on a Windows 2000 Server machine.
>
> I have an old spread*** that when I open it, I get the macro warning:
> "Macros are disabled because the security level is set to High and a
> digitally signed Trusted Certificate is not attached to the macros. To
> run
> the macros, change the security level to a lower setting (not
> recommended),
> or request the macros be signed by the author using a certificate issued
> by
> a Certificate Authority."
>
> When I go to look for any macros in the workbook (ALT-F8), the list is
> blank. Where else could there be a macro that would trigger this warning?
>
> Thanks,
> John Schneider
>
>
>
- Next message: dj.jimmi_at_gmail.com: "Change Number to Actual Text"
- Previous message: GF: "Excel webquery questions"
- In reply to: John Schneider: "Macro Warning, But No Macros!"
- Next in thread: Paul B: "Re: Macro Warning, But No Macros!"
- Reply: Paul B: "Re: Macro Warning, But No Macros!"
- Reply: John Schneider: "Re: Macro Warning, But No Macros!"
- Messages sorted by: [ date ] [ thread ]