Password Enabling Printing VBA (Specific Sheet)

[Rungravee Boonsud]

I am looking to LOCK the printing activity in the excel UNLESS the user has a password and specific worksheet.

I am frustrated and need help. Please.

Thank you very much for kindly advise,
Rungravee.

 

[Yongle]

replace

MsgBox "Wrong password"

with

MsgBox "Wrong password" & vbCr & vbcr & secret

 

[Rungravee Boonsud]

It's cannot too,

I want to mask password when input the box[h=1][/h]

 

[Yongle]

If you want to do that
- create a userform
- call the userform instead of input box or message box

 

[Rungravee Boonsud]

sorry for my disturb,
But i cannot use userform before

Can you advise this case

Note : I can only create a userform

 

[Yongle]

watch this video
- it shows you how to mask a password
- adapt to suit your needs

https://www.youtube.com/watch?v=Bc7UdEum-FY