Code triggers if someone opens a specific workbook

[Xenta]

Heya, how do you trigger the code on how to see if someone opens a vba on that workbook?

 

[6StringJazzer]

What specifically do you mean by "opens a vba on that workbook"? Do you mean if they open the macro code development window? Run a macro? Something else?

 

[Xenta]

What specifically do you mean by "opens a vba on that workbook"? Do you mean if they open the macro code development window? Run a macro? Something else?

Sorry for the late reply.
yes, if they try to view the code for the macros in that workbook. I tried putting a password but I saw some macros that are able to remove the VBA's password, so I was planning on making a code that would close the excel if someone else tried to view the codes.

 

[6StringJazzer]

First, I know of no way to cause VBA code to run if someone opens the VBA development window. I'm not going to tell you it's impossible, but I have no idea how you could do that.

Second, it sounds like you are trying to put some sort of security on the code. Excel is notoriously weak when it comes to security. The security is generally good for compliant users but not malicious users. In your case, even if you could create code to close the workbook, the user has to simply disable macros and then your code won't run.

You may need to consider other options, like a commercial Excel compiler that will bundle your Excel file into a format where the code cannot be read.

 

[Xenta]

First, I know of no way to cause VBA code to run if someone opens the VBA development window. I'm not going to tell you it's impossible, but I have no idea how you could do that.

Second, it sounds like you are trying to put some sort of security on the code. Excel is notoriously weak when it comes to security. The security is generally good for compliant users but not malicious users. In your case, even if you could create code to close the workbook, the user has to simply disable macros and then your code won't run.

You may need to consider other options, like a commercial Excel compiler that will bundle your Excel file into a format where the code cannot be read.

I see, thanks for the suggestion