Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet referencing in a cell | Excel Discussion (Misc queries) | |||
Referencing every 5th cell in another sheet | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
referencing a cell on another sheet | Excel Programming | |||
Referencing a cell containing sheet name | Excel Programming |