-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Protecting VBA from viewing
- Thread starter Antony
- Start date
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
To protect the project from being viewed:
1. Open the VBE
2. Goto Tools|VBAProject Properties
3. Choose the "Protection Tab"
4. Stick your password in.
5. Close and reopen the workbook and the VBA code will require a password to be viewed.
VBA doesn't compile, or at least not in the sense of a stand-alone application. To get some performance results when your project is ready to be shipped:
1. Open the VBE
2. Choose Debug|Compile VBAProject
This doesn't "compile" the VBA project in the sense that you "compile" a VBA project, or more accurately a C or C++ program.
However, compiling the project in this manner creates p-code or whatever the heck it's called, which basically means that your code will work quicker straight out the box.
HTH
1. Open the VBE
2. Goto Tools|VBAProject Properties
3. Choose the "Protection Tab"
4. Stick your password in.
5. Close and reopen the workbook and the VBA code will require a password to be viewed.
VBA doesn't compile, or at least not in the sense of a stand-alone application. To get some performance results when your project is ready to be shipped:
1. Open the VBE
2. Choose Debug|Compile VBAProject
This doesn't "compile" the VBA project in the sense that you "compile" a VBA project, or more accurately a C or C++ program.
However, compiling the project in this manner creates p-code or whatever the heck it's called, which basically means that your code will work quicker straight out the box.
HTH
Upvote
0
