Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macros?
I have an excel program that has a number of macros. I would like t give the program to a friend and would like him to have the ability t use the macros but not the ability to see or read the macros. Is thi possible? I am working with Microsoft Excel 2000 -- neb ----------------------------------------------------------------------- nebb's Profile: http://www.excelforum.com/member.php...nfo&userid=898 View this thread: http://www.excelforum.com/showthread.php?threadid=26980 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Macros?
nebb, protect your VBA project. To protect the VBA project, from your
workbook right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, in the left hand window right click on your workbook name and select VBA project properties, protection, check lock project for viewing and set a password. Press Alt and Q to close this window and go back to your workbook and save and close the file. Be aware that this password can be broken by third party software -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** "nebb" wrote in message ... I have an excel program that has a number of macros. I would like to give the program to a friend and would like him to have the ability to use the macros but not the ability to see or read the macros. Is this possible? I am working with Microsoft Excel 2000. -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=269809 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Macros | Excel Discussion (Misc queries) | |||
Hiding Macros | Excel Discussion (Misc queries) | |||
hiding macros | Excel Programming | |||
Hiding macros | Excel Programming | |||
Hiding my macros | Excel Programming |