Hi HarpsCardiff,

Setting the Protect method's UserInterfaceOnly parameter to true enables vba
manipulation of the protected sheet.

However, this setting is not persistent and needs to be reset each time the
workbook is opened.

Perhaps, therefore, you could set protection in the Workbook_Open or
Auto_Open procedures, e.g.:

'=============
Sub Auto_Open()
With Worksheets("sheet1")
.Protect Password:="drowssap", _
UserInterfaceOnly:=True
End With
End Sub
'<<=============


---
Regards,
Norman


"harpscardiff"
wrote in message
...

I got it working but..... As I need to proctect the sheet, I get a
runtime error; 1004, - Unable to set the NumberFormat Property of the
Range Class.

Is there any way around this, besides not locking the worksheet?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=500562