Make them press a button according to who they are. Put a macro behin
that button that unprotects the particular bit you want them to be abl
to change. Then make an automatic macro run on the close event for th
workbook (look up further stuff on events) basically write this int
your code in the workbook bit in the project explorer:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

' make it re-protect here.

End Sub

If you don't trust them to press the right button then maybe you ca
make them login to excel or something, use an inputbox and find out wh
they are via a username (hard code it probably easiest), then you ca
add a password if they are total muppets to make it even safer. Ther
must be a hundred ways of making sure of this I imagine

--
gearo
-----------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=40191