Quick Excel VBA syntax question

[westma]

Hello, I am trying to change the value in a cell only if the worksheet is protected, but I can't seem to find the correct syntax. The code is as follows

If [Worksheet g is not protected] Then
    g.Cells(1, 3).Value = 1
End If

I don't want excel to attempt to write the value in the locked cell when the sheet is protected and cause an error.

Thanks

 

[PHV]

Have a look at the Worksheet.ProtectionMode property and the Worksheet.Protection object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

Depending on the logic for your sheet, you may want to turn protection OFF before your code runs, and then turn it ON.

Skip,

_[red][/red]