| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Form for User-friendly Macros? | Excel Discussion (Misc queries) | |||
| Making macros available to other excel files | Excel Discussion (Misc queries) | |||
| macros making files slower and slower | Excel Discussion (Misc queries) | |||
| Making Macros Available in All Workbooks | Excel Worksheet Functions | |||
| Macros making file saving extremely slow. | Excel Discussion (Misc queries) | |||
Linear Mode
