Solved

Excel Macro password hack needed

Posted on 2001-07-03
3
2,227 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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 create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

695 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