Hi

I have made some macros that among other things gets data from SQLserver
with QueryTables. And it works fine.

The problem is: The Worksheets should be protected, and I have tried to put
unprotect first in the code, and protect in the end of the code. Unprotect
works fine, but the protection takes effect too early, so I get the error
message: Can not write to protected cells.

I use .RefreshBackgroundQuery=True

Is there any way to say that all code should be executed (and finished)
before the next code line can start?

Frank