Solved

Microsoft Excel Security

Posted on 2004-08-19
2
294 Views
Last Modified: 2010-04-11
I have excel sheet , and VBA programming that have security with password Protection. The problem is it is not secure as there are software available to recover Excel and VBA password Recovery. Anybody can retrieve the password and then can change the excel/VBA to its specifications.

So what can be done so that nobody can change the excel programming even if he retrieves or he cant retrieve the file. May be password encryption will be better idea. Can anyonce help me how to do that.

Regards...

Aejaazzz
0
Comment
Question by:aejaz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 38

Accepted Solution

by:
Rich Rumble earned 125 total points
ID: 11860635
The strongest password in all of M$ Office's applications is the password to open... vba passwords, and passwords to modify can be removed or found instantly using Elcomsoft's recovery tools- or similar. Password to OPEN, basically should force someone to Brute-Force the document to find the pass, and if the pass is 10 or more characters long it'd take years to recover, even at the CPU speeds of today. M$ office also allows you to change the encryption algorythims from the default (RC4 for office 2000 and office XP) to stronger alog's, RC4, RSA, AES etc... no matter which you go with, you have to use a long, and as complex as you can remember, password.
http://www.securiteam.com/windowsntfocus/6K003150KG.html (just don't use "VelvetSweatShop" as your password to open, if you do, when prompted for a pass, just press enter)

Just go to Save As... then on the top right of the Save As window, go to Tools, then General Options, then Advanced, and select a different cipher, stay away from office 97 compatible, and XOR
http://www.microsoft.com/office/ork/2003/seven/ch23/SecA06.htm
http://support.microsoft.com/default.aspx?kbid=263564
There can be issues with using different types of encryption, and different versions of Office... you may not be able to decrypt a document on an Office 2000 machine, that was encrypted using a Office XP installation... make back-up's and encrypt them in a Zip file- again using long complex password- forcing the use of BF, which takes forever...
-rich
0
 

Author Comment

by:aejaz
ID: 11867307
Thanks .... its very helpful... atleast now ppl will hav to make effort to decrypt my sheet :D
U got the points
Regards..
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Email attacks are the most common methods for initiating ransomware and phishing scams. Attackers want you to open an infected attachment or click a malicious link, and unwittingly download malware to your machine. Here are 7 ways you can stay safe.
With the rising number of cyber attacks in recent years, keeping your personal data safe has become more important than ever. The tips outlined in this article will help you keep your identitfy safe.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Suggested Courses
Course of the Month6 days, 11 hours left to enroll

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question