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
 
Thanks for update Bill.

I did not know that fact about OpenOffice


Gord
 
You must log in or register to reply here.

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

How do I set a pop up window to focus? 1
Macro Compatability 1
Printing using Macros for Multiply Co-workers in Excel 2
Excel Delete Multiple Page Breaks w/in Selected Rows 6
sharing macros with other users 3
Excel Macro question 4
Custom Toolbar Macro - Path Name 6
Macro to remove trailing spaces in cells 2

Back
Top