Can I locka worksheet so user cant see its vb coding

[Ateeb Ali]

Dear Sir
I have a excel sheet which password protected.

Though there are many macros in the file with vb coding.

When user click the different buttons link with different coding, it run first to unlock sheet, run macro then lock the sheet.

Now issue is every user can press ALT+F11 and can see the password of the sheet in VB modules.

Is there a way to restrict user that they cant go to VB modules or is there a way to hide the password in coding?

 

[Belleke]

It is in Dutch but the location should be the same.

 

[Ateeb Ali]

thanks its done

 

[Debaser]

Cross-posted here, FYI: https://www.mrexcel.com/forum/excel...worksheet-so-user-cant-see-its-vb-coding.html

 

[Ateeb Ali]

Cross-posted here, FYI: https://www.mrexcel.com/forum/excel...worksheet-so-user-cant-see-its-vb-coding.html

Yes I have posted there as well