How to hide the macro code that no one can open & see the code?

J

juma

Hi,

In Microsoft Excel, I am using a Visual Basic for Applications macro t
run an application.
I wanted to hide this macro/ code from other users except me.
Should we use password in order to open the code or is there somethin
available in EXCEL via which can hide the code?
How should we hide the macro so know one can open and see the code?

Thanks

Jumm
 
A

Arvi Laanemets

Hi

You can protect your VBAProject with password (right-click on VBAProject in
Project window, open properties, and set password on Protection tab) - then
without password the user don't see any code in modules and can't change
worksheets properties etc. Not very secure of-course, but enough for most
cases.
 
M

mudraker

juma

In the Visual Basic Editor you can protect your code with a password


Goto Tools menu > VbaProject Properties > Protection


Note: This is not a very sucure way to protect your code as there ar
many programs available that will crack your password with in seconds.


Using the Open workbook with a password is a much more secure feature

FROM Excel File menu > Save AS > Options Ta
 
Top