Check box that prompts for password

**mannosteele** · 10-05-2010, 11:02 PM

This is my first visit to this forum and I am nervous that my question will sound dumb but here goes. I have created a check box in a worksheet with C1 as its linked cell. In cell A1 is the formula IF(C1,"0",E1). Is there VBA code that will cause a prompt for password when the check box is checked, requiring that a correct password be entered before returning the "0" value? A password would not be required when un-checking the box. Also, if this can be done how would the prompt appear; a dialog box of some sort? And how do I create that? Sorry to be such a novice!

**pike** · 10-05-2010, 11:11 PM

Hi mannosteele
Welcome to the forum, have you seen this example
http://www.xcelfiles.com/API_09.html

**mannosteele** · 10-07-2010, 01:48 PM

Originally Posted by mannosteele

This is my first visit to this forum and I am nervous that my question will sound dumb but here goes. I have created a check box in a worksheet with C1 as its linked cell. In cell A1 is the formula IF(C1,"0",E1). Is there VBA code that will cause a prompt for password when the check box is checked, requiring that a correct password be entered before returning the "0" value? A password would not be required when un-checking the box. Also, if this can be done how would the prompt appear; a dialog box of some sort? And how do I create that? Sorry to be such a novice!

Fantastic ... thank you Pike! Took some modifying but the example you directed me to worked like a charm.