Hi all,

Using Excel 2007.

In cell $A$2 I would like the user to enter their password.
I would like to hide the contents of the cell so it does not display in the formula bar.
I also changed the font color to match the fill color of the cell.

The problem is I am using the Current Region Property on the worksheet
According to this KB on MSDN I cannot protect the worksheet while using the Current Region Property, so the password is still displaying in the formula bar.

Any thoughts on how I may get around this?
I do not know where the user is goiung to click to define the current region until run-time.

thx
w