How can I hide the code??

S

SanMartin

Can anyone tell me how to hide VBA code in a excel
applicatiuon so that users can't see it or modify
it.
 
R

Ron de Bruin

You can place Private before a sub like this
Private Sub test()

Or add this at the top of the module
Option Private Module

This way you don't see it in the macro list (Alt-F8)


You can Protect your project in the VBA editor

Alt-F11
In the menubar Tools>VBA project properties
See the protection tab

This way they can't see or edit your code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Create form with checkbox les that expand and collapse sections of the form? 0
To protect user's privacy 1
Loop through pages and insert header image 0
If statement based on cell formatting/style 2
Language independent VBA - hiding "blank" in pivot? 1
Need help modifying code 0

Top