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

suggest you protekt sheet with userinterfaceonly set so macro can rite with
sheet prtected

Sheet1.Protect "pass", True, True, True, True
Range("A1").Value = "CanWriteEvenWithSheetLocked"

userinterfaceonly is 4th true above.

"frankgtl" wrote in message
...
| 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
|
|