Greetings Excel Gurus!

I have a set of spreadsheets organized in a hierarchy which all link to
the spreadsheet above and below in the chain. These spreadsheets also
all contain macro's for 'automated' data input from the user.

I have two questions/requests.

1- Is there a way to avoid the Security Warning due to macro's? I
have to instruct all my users to drop the macro security to "medium"
and select "enable macros" each time the user opens the file. Is there
any way to avoid this?

2- Is there a way to avoid the pop up box requesting if you want to
update links or not? Frankly, a way that it would automatically pick
to update the links would be perfect.

Thanks for your time! And also, I don't consider myself fully
'proficient' with Excel just yet, infact previous to this project I
didn't really do any extensive VBA work at all. So please, provide as
much detail and explination as you can with any answers. Thanks again!


--
ph8
------------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871
View this thread: http://www.excelforum.com/showthread...hreadid=345781