Password reset

Status
Not open for further replies.

runningl33t

New Member
Joined
Jun 22, 2012
Messages
2
NOTE: The intention of this post is not meant for the breaking of password protection.

I'm working on making an excel tool in which certain private information is hidden and password protected. As part of the functionallity of the tool, i'm attempting to have a reset macro in which all information is deleted. This includes the private password protected information and the password itself. The goal of this is so someone can send someone else the tool and that they'd be able to reset it to "default" without seeing any of the private information. The problem is the macro will have to somehow bypass and reset the password protection.

I already have a macro set up to protect the sheet:
Code:
Columns("A:B").EntireColumn.Select
        Selection.EntireColumn.Hidden = True
        x = InputBoxDK("Please enter password", "Password")
        Z = InputBoxDK("Reenter password", "Password confrimation")
        If (x) = (Z) Then
            Sheets("Possible Exit Date").Select
            ActiveSheet.Protect Password:=(x), DrawingObjects:=True, Contents:=True, Scenarios:=True
            y = ("0")
        Else
            MsgBox ("Confimation password not identical")

but the only way I know to use a macro to unprotect a sheet is

Code:
ActiveSheet.Unprotect

but this asks for a password. Is what I'm looking for possible/legal?
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,882
Office Version
  1. 365
Platform
  1. Windows
As part of the functionallity of the tool, i'm attempting to have a reset macro in which all information is deleted. This includes the private password protected information and the password itself. The goal of this is so someone can send someone else the tool and that they'd be able to reset it to "default" without seeing any of the private information. The problem is the macro will have to somehow bypass and reset the password protection.
Please note that regardless of your intentions, we cannot help with any attempt to break, remove, or bypass any passwords. It is strictly forbidden by our rules. It doesn't matter what your intentions are (which we cannot verify anyhow), as someone else could use it for nefarious purposes.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,914
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top