how to give your VBA code password that you record in "thisworkbook"

Hello experts,

How can I give password to my vba code saved in "thisworkbook" so that the users cannot see inside my code where I have set a password for one of my worksheets.

It is a follow up question on a previous question:

https://www.experts-exchange.com/questions/28979577/How-can-I-set-password-for-a-sheet-in-excel.html?anchor=a41864063¬ificationFollowed=178318599#a41864063

Thank you.
tony01excel tonyAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,.

Go to the VBE
Tools / VBAProject Properties / Protextion
Tick Lock Project for viewing and enter your PW twice

Save Close and reopen it

Regards
0
 
tony01excel tonyAuthor Commented:
Great, thank you so much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.