Replace Update Links prompt
 

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!

Replace Update Links prompt
 

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!

Replace Update Links prompt
 

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!