Have written many macros and wish to protect them from prying eyes with password. Any way??? Thanks.
R Richard Apr 2, 2004 #1 Have written many macros and wish to protect them from prying eyes with password. Any way??? Thanks.
C Chip Pearson Apr 2, 2004 #2 Richard, In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then the Protection tab. There, check the "Lock Project For Viewing" check box and enter a password. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Richard, In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then the Protection tab. There, check the "Lock Project For Viewing" check box and enter a password. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com