Macro to unlock the protected workbook

[ronlau123]

Hi,

I have spreadsheet. Inside it, there are a few of sheets are protected. People can't insert/delete row. The coworker for this excel suddenly quit and no one know the password.

We can open the spreadsheet and we have 3 department also using the spreadsheet. I google how to unlock the protected excel, I find following macros. Now, I can insert/delete rows. However, other department manager think this is unsecurity to use macro from untrusted source.

May I ask is there any macro can find the password of protected excel. So that I can pass the password to other department to unlock .

Sorry that my question may be little bit strange. Thanks for your help.


Macro to unlock protected worksheet (However, as you press the button of Protected workbook , it still pop up the window to ask for your password).

[Code removed by moderator]

[FDibbins]

Your post does not comply with Rule 11 of our Forum RULES.

Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

Thread Closed