| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DISABLE "SAVE QUERY DEFINITION"
This deletes all querytables from ActiveSheet
Dim qtb As QueryTable For Each qtb In ActiveSheet.QueryTables qtb.Delete Next This approach will leave behind the named range for the querytable. If you're managing QueryTables you may be interested in the Query Editor Add-In on my website. -- Rob van Gelder - http://www.vangelder.co.nz/excel wrote in message oups.com... Is it possible to disable "save query definition" through macro. Basically I do not want any external data links saved in define names when I run query through macro. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to disable "save" prompt in excel file on web server? | Excel Discussion (Misc queries) | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
| Disable "save" option on close. | Excel Discussion (Misc queries) | |||
| Disable "Save" &/or "Close" | Excel Programming | |||
| disable save query definition in VBA sorry repost | Excel Programming | |||
![Rob van Gelder[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
