How can I lock worksheets while still allowing macros to operate?

[Guest]

When I lock the worksheets that macros should enter into while operating, I
get an error message. Then macros couldn't of course work properly. How can I
lock the worksheets and macros can still operate?

 

[Norman Jones]

Hi Enginguven,

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

 

[Guest]

Right click unto your macros and choose to format it. You should have a
protection tab, and de-select the lock box. If not go to the properties
under the right click. You should get another window, and it will have a
"lock" row, choose to make the lock feature "false".