• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

How to activate protected by password XlsX workbook to run unlocking macros

Hi
One of our employees left without giving us the password from an excel sheet. I hav running macros on my excel that can unlock the workbook, but I am not able to activate the protected workbook. How do I do it so I can run the macros on it?
Thx
0
samuelbp
Asked:
samuelbp
  • 2
  • 2
2 Solutions
 
Rory ArchibaldCommented:
What do you mean when you say you can't "activate" it? If you mean you can't open it without a password, then your macros won't work.
0
 
samuelbpAuthor Commented:
Exactly, isn't it an option to select the excel file from the vba window and then run the macro? I try to use this solution http://www.zorvek.com/excel/unlocking-workbooks-and-sheets.htm
0
 
Rory ArchibaldCommented:
No. The workbook open password cannot be broken that way. You need to buy software to break it or use a paid-for decryption service.
0
 
samuelbpAuthor Commented:
I've requested that this question be deleted for the following reason:

No solution provided
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now