Excel password protection

[kashew]

I need some help on unprotecting a spreadsheet. I've got an app that runs in an Excel spreadsheet written in VB. The main menu options FORMAT, TOOLS, DATA are disabled. I can get to the VB editor but I don't know enough about VB to figure out how to enable the menu options. I need to view all the pages and cells on the spreadsheet. Can someone provide me some instruction?

 

[dhulbert]

You need to get intouch with who ever wrote the spreadsheet and ask then for the password.

 

[xlbo]

As per dhulbert - this forum will not help you crack any passwords. Either talk to the original creator or utilise google

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[macropod]

Hi kashew,

Assuming you're not trying to 'crack' a spreadsheet's password, activating/deactivating password protection is quite straight forward.

In essence, you can unprotect, update then reprotect a worksheet with the following code:

ActiveSheet.Unprotect (“Password”)
' The rest of your code goes here.
ActiveSheet.Protect Pasword:=“Password”

where the string enclosed in quotes as “Password” contains the actual password (if used).

If you use the macro recorder as you activate/deactivate the protection options, you'll see how they're implemented too.

Cheers

 

[kashew]

This is an internal company spreadsheet. I finally found the author and got the password.