Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap a user to a cell.
Hi.
I have a file that I need users to enter a password before they can use it. Ideally, when the file opens a message box fires telling them to enter a password into cell A2. The passwords work on hidden vlookup tables which means that I can't password protect the file conventionally. Anyway, is there any code that will trap the user to a1, disable the mouse/pointer and direction buttons until a the value of the password has been met. Although there are many passwords they all will trigger a 1 if the found within the vlookup table. So therefore, if A1 = 1 then the file is released and normal controls apply. Hope this isn't too fiddly! Thanks G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a function that will trap & manage a change in cell value | Excel Programming | |||
I need a function that will trap & manage a change in cell value | Excel Programming | |||
how to trap cell cut and paste | Excel Programming | |||
how to trap cell cut and paste | Excel Programming | |||
How To Trap Cell Value Change Event so determine XL calc sequence? | Excel Programming |