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

Stop marco allert and update link allert when opening spreadsheet
 

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
HIS


"john conwell" wrote in message
...
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