Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links to Other Data Sources, Can't Turn off Application.DisplayAle
I have used Application.DisplayAlerts = False and Application.DisplayAlerts =
Many times in the past. However, I have never used this when opening and copying data from workbooks that contain links to other workbooks. I just tried to use some of Ron de Bruins code (GREAT STUFF RON): http://www.rondebruin.nl/copy3.htm Sub Basic_Example_1() €˜etc€¦ End Sub Im getting the standard message: €˜This workbooks contains links to other data sources Does anyone know how to turn this off? I dont want to click €˜Dont Update hundreds of times. TIA, Ryan--- -- RyGuy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links to Other Data Sources, Can't Turn off Application.DisplayAle
I just answered my own question:
Tools Options Edit Uncheck "Ask to update automatic links" Hope others benefit from my buffoonery. -- RyGuy "ryguy7272" wrote: I have used Application.DisplayAlerts = False and Application.DisplayAlerts = Many times in the past. However, I have never used this when opening and copying data from workbooks that contain links to other workbooks. I just tried to use some of Ron de Bruins code (GREAT STUFF RON): http://www.rondebruin.nl/copy3.htm Sub Basic_Example_1() €˜etc€¦ End Sub Im getting the standard message: €˜This workbooks contains links to other data sources Does anyone know how to turn this off? I dont want to click €˜Dont Update hundreds of times. TIA, Ryan--- -- RyGuy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where are the links to other data sources? | Excel Discussion (Misc queries) | |||
links to other data sources | Excel Worksheet Functions | |||
Links to other data sources | Excel Discussion (Misc queries) | |||
Links to other data sources | Excel Discussion (Misc queries) | |||
Links to other data sources | Excel Discussion (Misc queries) |