Try this:
ActiveSheet.Protect (userinterfaceonly)

You have to lock certain cells ahead of time, which you can do manually.
Then, when activesheet.protect is run, users can't modify things. The
userinterfaceonly option allows subroutines to continue w/
modifications.

Cells.Locked = True
might be usefull too. I believe that it will allow you to do the
locking of certain cells from a subroutine.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!