capturing password

[carsto]

First, I know passwords are easy to break. The point is only to keep the average Excel user in a dept of 3 from accidentally damaging the data.

Normally I hardcode passwords to view xlveryhidden sheets.

But this workbook is for a dept head who has standard password(s) he uses to open or edit a file. I would like to capture these passwords and make it the same password(s) to view a hidden sheet.

This way if he ever changes the password to open/edit it will automatically change the password to view the hidden sheet(s).

Possible?

[Leith Ross]

Your post does not comply with Rule 12 of our Forum RULES. Do not post questions with regard to breaking or bypassing a password of any type or post questions with regard to bypassing a users security settings, all such posts will be deleted, repeat offenders will be banned!

[carsto]

I'm not trying to break a password!

A department head gave me his workbook to automate. (And he gave me the password so I could work on it.)

I thought that it would be better for him if I used HIS open/edit password for other password purposes in HIS workbook. That way if he ever changes his open/edit password MY unhide sheet password would change with it. Otherwise he's stuck with my hard coded password to view a xlveryhiddensheet forever.

Unless you had the password to open the workbook, the code within that same workbook could never capture the password so it didn't seem controversial.

Perhaps giving me the answer to my innocent question would grant others knowledge we don't wish to disperse here, SORRY.

I LOVE THIS FORUM AND DON'T WANT A DEMERIT!

[royUK]

You might not be asking to break a password, but your idea could be misused.

[Leith Ross]

Hello carsto,

The forum's policy is to protect all parties. We expose ourselves and others to legal ligation when answering questions about security. If someone were to misuse the information provided to them by the forum to bypass security, legal action could be pursued. That is why we decline and discourage these questions.

[Macdave_19]

why not just put a piece of code that runs on the workbook opening.

if you use:

Please Login or Register  to view this content.

this way it's irrelivant what password he has coz it'll still show the sheets and allow changes to be made

[royUK]

Dave the OP said that he doesn't want to hardcode the password.

[Macdave_19]

oh right, oops

looks like he's stuffed then don't it!!

i see his point though, passware can be used to see it if he codes it!