Can I lock a worksheet so user cant see its vb coding

[ateebali]

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?

 

[nemmi69]

In the VBa page select the menu "Tools" option then select "VBaProject Properties..." . In the window that opens select the "Protection" tab. When its open check the "lock project for viewing" and below enter a password.

 

[ateebali]

Really thankful all done

 

[Logit]

.
Please be reminded that the security of Excel is very, very poor. There are many examples on the internet how to by pass
the security which "hides" the VBA code.

 

[SpillerBD]

I have a macro that ask for the password to open a file. That way the password is not risked and adapts to changes to the password without having to update the VBA.
In my case the macro crates many new files with the same password as the original file.

 

[Logit]

.
I'm not certain I understand your point.

If I do understand correctly, you have created a macro that requires the user enter the correct password to simply open the workbook. Without the correct
password, the user never gets to see the worksheet/s ? Even that can be bypassed with instructions on the internet, very easily.