Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Sheet to Prevent Viewing
Is there a easy follow up instruction on protecting sheet from viewing?
Here is what I find from Q&A, I tried but could not figure it out how it work. Right Click the Sheet tab and select "View Code" then add the following code. You can change the password to whatever you like. Private Const Password As String = "DoubleOhSeven" Private Sub Worksheet_Activate() Me.Visible = False If InputBox("Please Enter the Password for the " & Me.Name & " Sheet", "Enter Password") < Password Then Me.Visible = False Else Me.Visible = True End If End Sub -- Thanks, Aline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting my formulas from viewing | Excel Discussion (Misc queries) | |||
hide a page and prevent outside users from viewing it. | Excel Discussion (Misc queries) | |||
Protecting Excel file to prevent changes | Excel Discussion (Misc queries) | |||
Protecting Sheet to Prevent Viewing At All | Excel Discussion (Misc queries) | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions |