Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost: Disabling Update Links dialog box
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost: Disabling Update Links dialog box
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost: Disabling Update Links dialog box
Hi,
I am not using the Workbook open method to open. Rather we simply open the Excel Workbook from the File|Open Thanks, Sandeep "Jim Cone" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repost: Disabling Update Links dialog box
"but want to do this programmtically"???
- Maybe: Tools | Options | Calculation (tab) and uncheck "Update remote references". -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Sandeep" wrote in message Hi, I am not using the Workbook open method to open. Rather we simply open the Excel Workbook from the File|Open Thanks, Sandeep "Jim Cone" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Avoid Update Links dialog in Excel 2003 | Links and Linking in Excel | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
how to make the links info dialog box not appear | Excel Worksheet Functions | |||
Update dialog box | Excel Worksheet Functions |