Solved

VBA Coding

Posted on 2013-07-01
7
459 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

863 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

17 Experts available now in Live!

Get 1:1 Help Now