| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unprotect,refresh then protect again
you have to set the Backgroundquery property of the query to False so the
code will wait for the refresh to complete. -- Regards, Tom Ogilvy "Deeds" wrote in message ... I am having a big problem trying to 1st. unprotect a sheet, in the same code run "refresh all", then protect the sheet again. I keep getting an error like it is trying to "refresh" after the sheet is protected again...Can anyone explain how I unprotect, refresh then protect again? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect, unprotect | Excel Discussion (Misc queries) | |||
| Protect/Unprotect Worksheet | Excel Discussion (Misc queries) | |||
| Is there any way that you can protect or unprotect a group of wor. | Excel Discussion (Misc queries) | |||
| Protect/unprotect all worksheets | Excel Worksheet Functions | |||
| Protect\Unprotect VBA project | Excel Programming | |||
Threaded Mode
