Making macros unvisible
in [General]
|
Prev: Pivot Table date format
Next: Fitting to scale?
From: Byron720 on 14 Jan 2010 09:43 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.
From: Eduardo on 14 Jan 2010 10:00 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.
From: Bill Sharpe on 14 Jan 2010 18:23 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
From: Gord Dibben on 14 Jan 2010 18:41 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 <wfsnopam(a)adelphia.net> 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
From: Bill Sharpe on 15 Jan 2010 11:12
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 |