Thread: Cell Auto Lock
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Cell Auto Lock

We are maintaing an excel sheet for banking details, After entering
the data on every cell need to Lock with Password.
Please help me.

Please find the attachment


+-------------------------------------------------------------------+
Filename: Test.jpg |
Download:
http://www.excelbanter.com/attachment.php?attachmentid=976|

+-------------------------------------------------------------------+


Basically, you have to 'password protect' the worksheet. Look in the
help for 'Sheet Protection' or 'Worksheet.Protect'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion