| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Sheet
Hi
I used this code to protect my sheet Private Sub Worksheet_Activate() psw = InputBox("Please insert password to view data.", "Password Checker") If psw = "EPM" Then Sheets("ABD").Select Else MsgBox "Incorrect Password" End If End Sub But, even if i insert the wrong password my sheet become visible/active. Pls tell me where i am wrong. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting a Sheet | Excel Discussion (Misc queries) | |||
| protecting formulas without protecting sheet so grouping still wor | Excel Discussion (Misc queries) | |||
| protecting a sheet | Excel Discussion (Misc queries) | |||
| Can't use tab after protecting sheet. | Excel Worksheet Functions | |||
| Can't use tab after protecting sheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
