Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |