Securing Excel Sheet.

Hi All,

This is related to Visual Basic Application (excel)
My question is :
I have a new excel sheet open and if we press ALT+F11 from Excel Sheet, it will open the Visual Basic Application or code window.
What should I do to secure my code?, like entering a user name and password before it opens the VB code window.

Also, I heard some one saying even though if you secure (asking for U.nane and PWD before entering to the VBA or VB code), it is very easy to break in to code. Is it true?

Please help me out to secure excel sheet.


Thanks
Have a good day
Tpaul_10Asked:
Who is Participating?
 
FaircoConnect With a Mentor Commented:
VBA password is one of the easiest to recover, since there's a built-in backdoor in Excel that enables bypassing of the password. Like byundt said, several commercial applications exist for activating the bypass method.

If you really want to protect your code, you should consider using the DRM-like document security system implemented in Excel 2003. Only users selected by the author can view (or modify) the workbook, and it requires .NET passport authentication from everyone acessing it. The security uses a more complex encryption to the whole document, therefore it can't be simply bypassed. Kinda strong stuff and well designed. I recommend taking a look at it. One drawback is that only Excel 2003 can fully decrypt the document, therefore everyone accessing it must have Excel 2003. You can set Excel 2000 compatibility for viewing, but that's really weak.
0
 
Mike TomlinsonConnect With a Mentor Middle School Assistant TeacherCommented:
This PAQ explains how to do it:
http://www.experts-exchange.com/Applications/MS_Office/Q_10293525.html

I don't know how secure or easy it is to break this security feature though.

~IM
0
 
byundtConnect With a Mentor Commented:
If you do a Google search for Excel VBA password crack, you will find a number of sources for commercial products that purport to break the password protecting a VBA project. It's harder to crack than the password protection for worksheets, but still relatively inexpensive in terms of time and money.

Compiled VB code will be more secure (as an add-in) than VBA.

If you stick with VBA, you should consider obfuscating your code. This involves:
1) Multiple instructions on each line of code, with no "structuring" for readability
2) Variable names should be as similar as possible--random combinations of letters and numbers are excellent choices
3) Include extra instructions that don't actually do anything--but look as though they are
4) Don't comment anything
0
 
Tpaul_10Author Commented:
Thanks to all of you Guys.
All of your feedback and information is very usefull.

Thanks
Have a great day
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.