Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protect data entry to cell
I have a large workbook that has the majority of cells
locked and password protected. There are several cells left unprotected to allow for data entry. On one worksheet, the FrontPage sheet I have five cells that I need to stop data entry from anyone other that the manager of the section. Can I use code and an a message input box to accept a suitable password to allow data entry to these cells. The code could include unprotect range. I am currently using .enable and .disable to allow acces to the cells. whenthe first cell has data added it gives acces to the second cell etc. I need to password protect access to the first cell, and each other as they become available. Hope this makes sense, Thanks in advance to anyone who can help with code. Regards Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect all excel tabs in a file with one password entry? | Excel Discussion (Misc queries) | |||
Protect Data after entry | Excel Discussion (Misc queries) | |||
Protect IF statement AND allow data entry | Excel Worksheet Functions | |||
Howdo I password protect a list entry | Excel Programming | |||
Need way to protect cell after data entry | Excel Programming |