Making macros unvisible

B

Byron720

I have a database where you type a part # and (by using macros) it brings up
the different storage locations for that part. How do I make that macro
invisible or password protected? I can use Security on high but there are
other co-workers who know that.
 
E

Eduardo

Hi,
go to visual basic, tools, Project properties, 2nd tab protection, write a
password

if this helps please click yes thanks
 
B

Bill Sharpe

Eduardo said:
Hi,
go to visual basic, tools, Project properties, 2nd tab protection, write a
password

if this helps please click yes thanks
Click to expand...

Be aware it's not that difficult to bypass or "break" password
protection in Excel.

Bill
 
G

Gord Dibben

VBA Project Passwords are not easily broken.

Internal Passwords for sheet and workbook protection are easy to break.


Gord Dibben MS Excel MVP
 
B

Bill Sharpe

Gord said:
VBA Project Passwords are not easily broken.

Internal Passwords for sheet and workbook protection are easy to break.


Gord Dibben MS Excel MVP
Click to expand...

Gord
I've been able to bypass some VBA passwords just by opening the file in
OpenOffice.org.
True, I can't run the code, but I can view it.

Bill
 
Top