Making macros unvisible
 

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.

Making macros unvisible
 

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

if this helps please click yes thanks

"Byron720" wrote:

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.

Making macros unvisible
 

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

if this helps please click yes thanks

"Byron720" wrote:

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.

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

Bill

Making macros unvisible
 

VBA Project Passwords are not easily broken.

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


Gord Dibben MS Excel MVP

On Thu, 14 Jan 2010 15:23:48 -0800, Bill Sharpe
wrote:

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

if this helps please click yes thanks

"Byron720" wrote:

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.

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

Bill

Making macros unvisible
 

Gord Dibben wrote:
VBA Project Passwords are not easily broken.

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


Gord Dibben MS Excel MVP

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

Bill


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

Making macros unvisible
 

Thanks for update Bill.

I did not know that fact about OpenOffice


Gord

On Fri, 15 Jan 2010 08:12:00 -0800, Bill Sharpe
wrote:

Gord Dibben wrote:
VBA Project Passwords are not easily broken.

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


Gord Dibben MS Excel MVP

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

Bill


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