Run macro in protected worsheets

[frankgtl]

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

 

[Homey]

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.

| 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
|
|