0

I have an excel sheet from third party in which the VBA is password protected. I could not add any additionally code to the VBA editor sheet.

I need functionality like this :

I have three cells with value of 'true'. I would like to change these three cells to 'false' with a single click. (Basically I need some emergency functionality in which I could turn all the cells to false with a single click).

How could I work around that without the VBA?

Community
  • 1
  • 1
Steveng
  • 1,451
  • 4
  • 15
  • 14
  • 1
    To incorporate that functionality you will have to get the password for the 3rd party app. Ethically, hacking the password for a 3rd party app is not right. Imagine if someone does that to your application? I would recommend getting in touch with the 3rd party and asking them for the password or requesting them to incorporate the functionality that you want. – Siddharth Rout Jun 21 '12 at 10:06

1 Answers1

0

Anything that requires buttons and actions on click events will require some VBA unfortunately.

However, if your workbook is in the "old" .xls format (2003 and earlier versions - if it's not, I think you can just Save As... using 97-2003) you may be able to remove the VBA password using a Hex editor. You can't recover it, but you can replace it.

This answer actually explains it very well, but in short you create a dummy workbook with a known password, find some keys in the hex editor and replace the same in your locked workbook with your value from the dummy book.

Community
  • 1
  • 1
Widor
  • 13,003
  • 7
  • 42
  • 64