Stop marco allert and update link allert when opening spreadsheet

When the macro security settings are set to High or Very High, i get a
warning each time I open a spread sheet that states that macros are turned
off. I dont want to see this warning at all.

Like wise, if a spreadsheet has links that need to be updated, when i open
the spreadsheet I get a popup that states this fact and offers me several
options. I dont want to see this either. I dont want links updated, and I
dont want a popup.

What I want is to open a spreadsheet and not get ANY popups. Is there a way
to write a macro to turn these two warning off when i open my spread sheet?

THanks,
John C

John

No, not really, it would slightly defeat the object if you could switch off
the macro warning with a macro. You can only set you protection to low to
avoid it (not recommended)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"john conwell" <[email protected]> wrote in message
news:[email protected]...
> When the macro security settings are set to High or Very High, i get a
> warning each time I open a spread sheet that states that macros are turned
> off. I dont want to see this warning at all.
>
> Like wise, if a spreadsheet has links that need to be updated, when i open
> the spreadsheet I get a popup that states this fact and offers me several
> options. I dont want to see this either. I dont want links updated, and
> I
> dont want a popup.
>
> What I want is to open a spreadsheet and not get ANY popups. Is there a
> way
> to write a macro to turn these two warning off when i open my spread
> sheet?
>
> THanks,
> John C