#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default protect VB-code

Hi,

Is there a way to protect a Module or a Form with a password
separately so that the code isn't visible?

Or is the only way to protect it by using the password option in the
project properties?

Cheers,

Harold
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default protect VB-code

You cannot protect individual VB Components. You can password protect the
entire project or nothing at all. Note that the password protection provided
by the VBA editor is very weak. It should be considered to protect the
honest user from honest mistakes. It is not strong enough to protect
proprietary code or code with intellectual property value. For that level of
protection, you should be writing your code in VB6 or NET.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"mohavv" wrote in message
...
Hi,

Is there a way to protect a Module or a Form with a password
separately so that the code isn't visible?

Or is the only way to protect it by using the password option in the
project properties?

Cheers,

Harold


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to protect/unprotect a sheet using a macro with password FredH Excel Discussion (Misc queries) 5 October 23rd 07 04:49 PM
Protect Workbook Vs Protect Sheet Poor_pakistani New Users to Excel 4 May 25th 06 02:06 PM
Code to protect sheet Conditional Formatting Excel Worksheet Functions 1 December 21st 05 11:04 PM
How do I protect Visual Basic for Application Code Zagrijs Venter New Users to Excel 6 August 5th 05 09:24 PM
password protect vba code greg Excel Discussion (Misc queries) 3 December 8th 04 04:03 PM


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"