The Workbook Open method has an optional Update Links argument.
There are four values you can apply. See the Excel VBA help file to find the
appropriate value.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Sandeep"
wrote in message
When i open the excel workbook, i get a dialog pop up, asking to update the
links present in the Excel workbook(as used cells refers to the underlying
macros)
I want to disable this dialog programmtically when i we Open the workbook
directly by double click or File|Open.
I know, we can set the option from Edit|Links to disable this pop-up or from
the start-up under options but want to do this programmtically.
Please help.
Thanks,
Sandeep