Cheers all!

I kindly request your help with the following task:

I got two Workbooks with Range Names that refer to each other (i.e
Range Names in Workbook 1 refer to ranges in Workbook 2, and th
opposite).

The user will always open Workbook 1 first.
I have enabled Workbook 2 to open automatically when Workbook 1 i
opened (with the Workbook_Open event).

The 'problem':
As expected, when I'm opening Workbook 1 (thus causing Workbook 2 t
open as well) I'm getting prompts about whether I want to updat
Workbook1 with the info on Workbook 2.
The same prompt appears when Workbook 2 is opened automatically.

The task:
Is there any way that the updating takes place automatically in th
background for both Workbooks, and no prompts are shown to the user?

Thank you very much for your time!

Kind regards,
Ale

--
Alex Hatzisava
-----------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26812