close
pls let me know how to create using marco. I have create marco like this.
Sub linkS1()
myPWD = Application.InputBox(quot;Password Protected! Please Enter Authorized
Password to Continue!quot;)
If myPWD = quot;ems5657c1s1quot; Then
Sheets(quot;S1quot;).Select
Range(quot;A3:G3quot;).Select
Else
MsgBox quot;Wrong Password! Bye!quot;
End If
End Sub
* the reason is, user still able unhide or using commandbar to display the
tab sheet. That mean, user still able to access without password.
TQ
Param
全站熱搜
留言列表
