locked cells and code

[Guest]

If cells are 'locked' I have found that data which is supposed to be
inserted by code isn't.
Is there a way around this?

 

[Trevor via OfficeKB.com]

The code needs to unprotect the worksheet before updating the cells and, if
required, protect the worksheet after updating the cells.

 

[Guest]

Jock,

Unprotect make you changes and then reprotect at runtime

Sub standard()
ActiveSheet.Unprotect Password:="Mypass"
'Make your changes
ActiveSheet.protect Password:="Mypass"
End Sub

Mike

 

[Guest]

Thanks to Trevor & Mike
--
Traa Dy Liooar

Jock

The code needs to unprotect the worksheet before updating the cells and, if
required, protect the worksheet after updating the cells.