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