Protect/Hide the Macro or VB Script function

jeremy · Feb 21st, 2002, 04:20 AM

How can i protect/prevent user from editing or accessing the Macro or VBScript functions that i wrote for my Excel Template ?

Best regards
Jeremy

Mudface · Feb 21st, 2002, 04:50 AM

In the Project Explorer pane, right click on the name of your project and select VBAProject Properties. This will allow you to enter a password to view your code.

jeremy · Feb 21st, 2002, 11:53 PM

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 04:20 AM	#1
jeremy New Member Join Date: Feb 2002 Posts: 2	How can i protect/prevent user from editing or accessing the Macro or VBScript functions that i wrote for my Excel Template ? Best regards Jeremy

Feb 21st, 2002, 04:50 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	In the Project Explorer pane, right click on the name of your project and select VBAProject Properties. This will allow you to enter a password to view your code.

Feb 21st, 2002, 11:53 PM	#3
jeremy New Member Join Date: Feb 2002 Posts: 2	Thanks