Password protect data entry to cell
Brian
Which version of Excel?
2002 and 2003 have under ToolsProtection "allow users to edit ranges"
You can set passworded access to cells for these users.
Gord Dibben Excel MVP
On Fri, 23 Apr 2004 15:12:23 -0700, "Brian"
wrote:
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
|