Hi,

I am not a guru with Excel and need guidance, suggestions, examples,
sources, etc...

Scenario: Open a Spreadsheet in MS Excel. Within the spreadsheet is a
button, when clciked, opens a master spreadsheet, completes any updates and
then closes. This works fine.

Problem: As new versions of MS Excel will be deployed, the macro security
will be set, which means the macro will fire the warning.

Option1: How can this be set temporarily through code to stop the warning,
to include allowing the macro to complete is work.

Option2: Open the spreadsheet in MSIE Browser, and complete the updates.
Provide a link, which opens the master document, which can then be saved.
Pressing the back button in MSIE, close the master spreadsheet, and then asks
to reopen the original spreadsheet. is it possible to have a button in the
spreadsheet, that will open the master spreadsheet in MSIE, complete a save /
update, and then close the master sheet, and reopen the calling sheet,
without having to clcik yes, save, etc...?

Option3: Any alternatives????

Thanks,
GSR