Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Auto Lock
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| +-------------------------------------------------------------------+ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Auto Lock After Entering | Excel Worksheet Functions | |||
Cell Auto Lock After Entering | Excel Programming | |||
Auto-lock a cell once it's updated | Excel Worksheet Functions | |||
auto caps lock | Excel Discussion (Misc queries) | |||
Lock or Unlock cell references in a formula for auto fill purposes | Excel Discussion (Misc queries) |