Solved

Excel Macro password hack needed

Posted on 2001-07-03
3
2,224 Views
Last Modified: 2007-12-19
We had an employee leave the company and who we now find has password protected write access to several macros in an important spreadsheet.

When I try to edit the macro normally, I can select the Macro, but all options are then greyed out except the ability to run it. We need to edit it.

I tried to save the spreadsheet to Excel 95 version, but it won't let me with a "VBA Project password protected".

Is there any way to defeat the Excel Macro Password in the Visual Basic Editor?

Thanks,
Chuck

0
Comment
Question by:appelq
[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
  • 3
3 Comments
 
LVL 13

Expert Comment

by:cri
ID: 6250465
Go to any search engine, like www.google.com and give Excel password recovery as keywords. The choice is yours.
0
 
LVL 13

Expert Comment

by:cri
ID: 6250475
Ah...put VBA into the search too.

This seems to be capable, never tried it though

http://www.lostpassword.com/vba.htm
0
 
LVL 13

Accepted Solution

by:
cri earned 50 total points
ID: 6250491
If the work was done with Excel 97 there is a free tool. See VBAKEY from Pathologist under http://www.password-crackers.com/crack1.html
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

726 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