Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes this is possible but tricky and prossibly not worth doing. You need to
catch the on change event in VBA and bring up a password form to authenticate the user. Conversly you could catch the NT username and authenticate off of that. Not exceptionally difficult to impliment, but a whole lot of work. As I like to say "Anything is possible but before we get started how much time and money do you have. Some things just aren't worth doing." "MarcB" wrote: ok this is a bit complicated. I have a cell that performs a math function and comes up with a number.. another cell allows the user to edit this "price" (like a manager's discount). What I want to do is if the price is < x then it requires the user to have level 1 access.. and if its x it requires the user to have level 2 access to the adjustment cell. Is this possible and what tools would be needed? Thanks for any help you can give me. -- MarcB ------------------------------------------------------------------------ MarcB's Profile: http://www.excelforum.com/member.php...o&userid=14988 View this thread: http://www.excelforum.com/showthread...hreadid=276354 |