Hello. I am distributing a template that has links. I have found that many
choose "No" to the update links prompt. Is there a way to:
1. Automatically update the links without the prompt or
2. Replace the standard prompt with a custom prompt giving more
information?

Thanks!

the prompt is provided based on the users individual settings. It occurs
before any code is run, so you have no control over it.



--
Regards,
Tom Ogilvy


"Steph" wrote in message
...
Hello. I am distributing a template that has links. I have found that
many
choose "No" to the update links prompt. Is there a way to:
1. Automatically update the links without the prompt or
2. Replace the standard prompt with a custom prompt giving more
information?

Thanks!

Hi Steph

There is a setting in ToolsOptions...Edit but you must set this on every machine
because it is not saved with the workbook.

Another option is to open your workbook with code from a other file.
Set mybook = Workbooks.Open(FNames, Password:="ron", WriteResPassword:="ron", UpdateLinks:=0)

< 0 Doesn't update any references
Use 1,2 or 3
See the VBA help





--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steph" wrote in message ...
Hello. I am distributing a template that has links. I have found that many
choose "No" to the update links prompt. Is there a way to:
1. Automatically update the links without the prompt or
2. Replace the standard prompt with a custom prompt giving more
information?

Thanks!