Update Links/Trust Macros?

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

Does anyone happen to know how to prevent Excel 2000 from prompting
the user to respond to the "do you want to update links?" and "are you
sure the workbook is from a trusted source, do you want to allow
macros to run" dialog boxes?

I would like Excel to default "no" to "update links" and "yes" to "run
macros". The answers must be as above for the workbooks to work
properly.

On our Intranet site, we have dozens of workbooks accessed by users
with varying technical experience. These dialog boxes can be
confusing and may be limiting the use of the spreadsheets.

If you have any ideas, I would appreciate it.

Regards,
Joel
 
It's user selectable based upon security settings. In Excel XP
it's found in Tools, Options, Security tab, Macro Security
button.

You can place some instructions in the spreadsheet telling
users how to fix the Macro Security settings.
 
Thanks for responding. If you could provide additional
detail on changing the macro security settings, I would
appreciate it (i.e. some sample VBA code).

Also, I'm using Excel 2000 so I don't see the
Tools,Options,Security tab. Does anyone know if there is
a similar feature in Excel 2000?

Regards,
Joel
 
Back
Top