Solved

VBA Coding

Posted on 2013-07-01
7
472 Views
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.


Thanks
0
Comment
Question by:itjockey
  • 3
  • 3
7 Comments
 
LVL 27

Expert Comment

by:MacroShadow
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.
0
 
LVL 8

Author Comment

by:itjockey
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.

Thanks
0
 
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.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 8

Author Comment

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

Accepted Solution

by:
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 http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/A_10805-Overcome-the-Trust-Center-Nuisance.html for several methods to accomplish that.
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 39289871
thanks for your information.......
0
 
LVL 27

Expert Comment

by:MacroShadow
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.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

861 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