VBA Coding

Posted on 2013-07-01
Last Modified: 2013-07-01
Hi Experts,

A.If workbook is password protected then is there is any way to crack it in Office 2010.

B.If workbook is password protected - if any one entered wrong password - then it delete all sheets (Except 1 which is predefine) - delete all module & VBA - change password to which one is entered.Before openning of workbook.

Question by:itjockey
  • 3
  • 3
LVL 26

Expert Comment

ID: 39289616
A. Yes there are ways to do it, but you won't get any information here as how to.
B. You can code to delete all sheets and modules, but I don't think you can have the code triggered by the internal excel protection, you will have to setup a custom password prompt.
This should give you a push in the right direction. If you need specific information please rephrase your question.

Author Comment

ID: 39289650
A. Yes there are ways to do it, but you won't get any information here as how to.

why I won't get any information here?

B. I don't mind with custom password.

Events - if any one insert wrong password - things done before opening.
Delete all sheets except one - delete all module - Code - even that code which is performing this task.
Set entered password as new password.
so it self destruction VBA.

LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 250 total points
ID: 39289837
If the workbook is password protected for opening, then I wouldn't even attempt it without commercial software.

For B, that's a waste of time. The user could simply disable macros.
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


Author Comment

ID: 39289845
For B but user don't have that kind of knowledge to disable macros.
LVL 26

Accepted Solution

MacroShadow earned 250 total points
ID: 39289858
Macros are automatically disabled on new files if security setting is set to high. To overcome that you have to manually add the new file (or it's location) to the list of trusted files (or locations). See my article for several methods to accomplish that.

Author Closing Comment

ID: 39289871
thanks for your information.......
LVL 26

Expert Comment

ID: 39289880
why I won't get any information here?
Because its against EE's regulations, we cannot assist in cracking, and that is in essence what you are asking.

You shall not engage in any of the following activities... or pirating software... Posting any content that infringes any third party’s intellectual property rights or violates any confidentiality Agreements, contracts of employment, licenses, “Terms of Use”, or copyright

The easiest way to accomplish your objective is by following these steps:
1. Prompting user for password on opening of file
2. Save entered password to temp file
3. if password doesn't match:
     a. disable breaking of code
     b. export the wanted worksheet to a new file, naming it the name of the original file.
     c. export the module containing the code to the new file
     d. set the new password in the exported module
3. Delete the original file.

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
My experience with Windows 10 over a one year period and suggestions for smooth operation
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now