Define lock. You can lock the cells and protect the sheet which will keep the
average user from being able to edit the information. There is nothing
foolproof to keep the expert user from hacking into your sheet though...
--
HTH...

Jim Thomlinson


"office3000" wrote:


Hello,
Is it possible to write a macro to lock a selected sheet for editing
when run?
Thanks in advance


--
office3000
------------------------------------------------------------------------
office3000's Profile: http://nettechguide.com/forums/member.php?u=393
View this thread: http://nettechguide.com/forums/showthread.php?t=2244965