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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike TomlinsonHigh School Computer Science, Computer Applications, and Mathematics TeachersCommented:
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
byundtMechanical EngineerCommented:
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
FaircoCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tpaul_10Author Commented:
Thanks to all of you Guys.
All of your feedback and information is very usefull.

Thanks
Have a great day
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.