Making macros unvisible

  • Thread starter Thread starter Byron720
  • Start date Start date
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.
 
Hi,
go to visual basic, tools, Project properties, 2nd tab protection, write a
password

if this helps please click yes thanks
 
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
 
VBA Project Passwords are not easily broken.

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


Gord Dibben MS Excel MVP
 
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
 
Back
Top