0

I think that question has been asked in different ways. But I didn't found a satisfying solution. I want to unlock a VBA-project using vba code. Possibly something like the .unprotect method for workbooks or -sheets. I know the password, I do not need to crack open the project.

Is there a simple way to realise this?

1 Answer 1

1

Thats not possible. The Password is not exposed in the VBA Object, so you cant directly access it trough VBA Code. There is only a method to send the keys for the password, but i wouldnt recommend it.

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for that answer. I guess it will work also without it, I do not want to bother with it for too long. have a great day!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.