| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to disable auto refresh
hi
is it possible to run a macro to disable/enable the automatic refresh on all queries in a workbook? thankyou |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to disable auto refresh
Application.ScreenUpdating = False Application.Calculation = xlCalculationAutomatic This is stop screen updating while running macro and will actually speed up the macro by 80%. If you want screen updating, just change the FALSE to TRUE "Patrick Bateman" wrote: hi is it possible to run a macro to disable/enable the automatic refresh on all queries in a workbook? thankyou |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to disable auto refresh
sorry i'm looking to disable the automatic refresh on a database query i have
in my sheet "ddiicc" wrote: Application.ScreenUpdating = False Application.Calculation = xlCalculationAutomatic This is stop screen updating while running macro and will actually speed up the macro by 80%. If you want screen updating, just change the FALSE to TRUE "Patrick Bateman" wrote: hi is it possible to run a macro to disable/enable the automatic refresh on all queries in a workbook? thankyou |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to disable auto refresh
Turn on the macro recorder and do it manually to one of your queries.
then turn off the macro recorder and look at the code recorded. -- Regards, Tom Ogilvy "Patrick Bateman" wrote: sorry i'm looking to disable the automatic refresh on a database query i have in my sheet "ddiicc" wrote: Application.ScreenUpdating = False Application.Calculation = xlCalculationAutomatic This is stop screen updating while running macro and will actually speed up the macro by 80%. If you want screen updating, just change the FALSE to TRUE "Patrick Bateman" wrote: hi is it possible to run a macro to disable/enable the automatic refresh on all queries in a workbook? thankyou |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to disable auto refresh
i have tried this a couple of times and it keeps causing excel to crash just
after i turn off the auto refresh? "Tom Ogilvy" wrote: Turn on the macro recorder and do it manually to one of your queries. then turn off the macro recorder and look at the code recorded. -- Regards, Tom Ogilvy "Patrick Bateman" wrote: sorry i'm looking to disable the automatic refresh on a database query i have in my sheet "ddiicc" wrote: Application.ScreenUpdating = False Application.Calculation = xlCalculationAutomatic This is stop screen updating while running macro and will actually speed up the macro by 80%. If you want screen updating, just change the FALSE to TRUE "Patrick Bateman" wrote: hi is it possible to run a macro to disable/enable the automatic refresh on all queries in a workbook? thankyou |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to disable auto refresh
If you are using a periodic refresh
for each sh in worksheets for each qt in sh.QueryTables qt.RefreshPeriod = 0 Next Next -- Regards, Tom Ogilvy "Patrick Bateman" wrote: i have tried this a couple of times and it keeps causing excel to crash just after i turn off the auto refresh? "Tom Ogilvy" wrote: Turn on the macro recorder and do it manually to one of your queries. then turn off the macro recorder and look at the code recorded. -- Regards, Tom Ogilvy "Patrick Bateman" wrote: sorry i'm looking to disable the automatic refresh on a database query i have in my sheet "ddiicc" wrote: Application.ScreenUpdating = False Application.Calculation = xlCalculationAutomatic This is stop screen updating while running macro and will actually speed up the macro by 80%. If you want screen updating, just change the FALSE to TRUE "Patrick Bateman" wrote: hi is it possible to run a macro to disable/enable the automatic refresh on all queries in a workbook? thankyou |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for auto refresh | Excel Discussion (Misc queries) | |||
| Running a macro from an auto-refresh | Excel Worksheet Functions | |||
| Disable Auto Refresh Dialog | Excel Programming | |||
| Auto-run macro after auto-query refresh (Excel2000,sr1) | Excel Programming | |||
| Macro Auto-refresh? | Excel Programming | |||
Hybrid Mode
