Lock the sheet with a macro instead of manually. When you lock it with a
macro, you can lock it from user input only, but leave other code free
to change things.

For instance, this code locks the sheets when the workbook opens, the
user can't change anything, but your macros could:

=============
Private Sub Workbook_Open()
'If you have different passwords
'for each Worksheet.
Sheets(1).Protect Password:="Secret", _
UserInterFaceOnly:=True

Sheets(2).Protect Password:="Carrot", _
UserInterFaceOnly:=True

'Repeat as needed.
End Sub
===============
Adjust for your needs.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48359