referencing a cell in a hidden sheet
 

Hello,
I use the code below to enable an authorized user to view a particular sheet.

Question:
Rather than having the password directly in the code, i want to refer to it
in another hidden sheet called 'ColumnMap'. How can I do this? What i am
trying (see below) isn't working


If InputBox("The 'Actual vs Budget' report has restricted access.
Please enter a password to continue") < Sheets("Actual vs
Budget").Range("Q3").Value Then
MsgBox "Incorrect Password"
Else
Worksheets("Actual vs Budget").Visible = True
Worksheets("Actual vs Budget").Activate
Unload Me
End If
--
Carlee

referencing a cell in a hidden sheet
 

Carlee
Please post back with more detail of what you have and what you want.
Is it that you have a number of passwords in the ColumnMap sheet, along with
a number of sheet names, one per password, and you want to unhide and
display the specific sheet that goes with the specific password? The code
that you have doesn't include the text "ColumnMap" and you say that's where
the password(s) are. Post back and you will get lots of help. HTH Otto
"Carlee" wrote in message
...
Hello,
I use the code below to enable an authorized user to view a particular
sheet.

Question:
Rather than having the password directly in the code, i want to refer to
it
in another hidden sheet called 'ColumnMap'. How can I do this? What i am
trying (see below) isn't working


If InputBox("The 'Actual vs Budget' report has restricted access.
Please enter a password to continue") < Sheets("Actual vs
Budget").Range("Q3").Value Then
MsgBox "Incorrect Password"
Else
Worksheets("Actual vs Budget").Visible = True
Worksheets("Actual vs Budget").Activate
Unload Me
End If
--
Carlee