| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if SHEET has QUERYTABLE property ?
Max,
Glad it works for you! Works for me, all the time. I have a special toolbar button for it... -- sb "max chen" wrote in message ... Thanks a lot After I set the backgroundUpdate option of the imported data area to false, The refreshAll do refresh all sheets. It's Great! max. ? Thu, 21 Aug 2003 13:02:04 -0700 ?, "steve" ??: Max, I think you can do it easily with this Application.DisplayAlerts = False Application.ScreenUpdating = False ActiveWorkbook.RefreshAll Application.ScreenUpdating = True Application.DisplayAlerts = True |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007: Property Sheet button disabled | Excel Discussion (Misc queries) | |||
| How to set text property of a check box to value of a cell? | Charts and Charting in Excel | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Best way to inser file property into and excel sheet (cell) | Excel Discussion (Misc queries) | |||
| Is there a Sheet delete property? | Excel Programming | |||
Threaded Mode
