ExcelBanter - Cell Auto Lock

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell Auto Lock (https://www.excelbanter.com/excel-worksheet-functions/450135-cell-auto-lock.html)

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

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

See sample code at this site. . . . .

http://answers.microsoft.com/en-us/o...6-9abd04e46108

Gord

On Thu, 5 Jun 2014 15:47:15 +0100, Moideen
wrote:

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|
+-------------------------------------------------------------------+