| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 Disabling "Refresh All" functionnality
Hi everyone,
Hopefully it is not a stupid question but I really searched before posting it... In External Data toolbar there is a "Refresh All" option. I would like to disable it but it should still be possible to refresh individual queries. Thank you in advance for your help ! Jérôme |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2003 Disabling "Refresh All" functionnality
guyzmofr wrote on 6/16/2010 :
Hi everyone, Hopefully it is not a stupid question but I really searched before posting it... In External Data toolbar there is a "Refresh All" option. I would like to disable it but it should still be possible to refresh individual queries. Thank you in advance for your help ! Jérôme You'd have to set the control's Enabled property to FALSE when appropriate, then when necessary set it to TRUE -or- provide a button that executes its procedure (while keeping it disabled). To disable: Commandbars("External Data").Controls("Refresh All").Enabled = False To execute its procedu Commandbars("External Data").Controls("Refresh All").Execute HTH -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling "cut" function - version 2003/2007 | Excel Worksheet Functions | |||
| Disabling the "&[Time]" or "&[T]" in Excel headers and footers | Excel Discussion (Misc queries) | |||
| having trouble disabling "save", "save as" (2003) | Excel Programming | |||
| Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
| Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) | |||
Linear Mode
