Establish the Unprotect Password
Hello,
I recently sent out about 200 workbooks, half with one protect password and the rest with another (for this purpose we will make the passwords passA and passB). What I am trying to do via Excel macro is establish what password that sheet is using.
Now I have tried
Now of course this doesn't work... any advise?
Please Login or Register to view this content.
Regards,
Last edited by jrheeder; 07-27-2010 at 06:47 AM. Reason: tmake it more readable
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
I have added them this time, maybe
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Re: Establish the Unprotect Password
Roy,Originally Posted by royUK
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
I have added them this time, maybe
Please Login or Register to view this content.
Apologies for the mistake I will endeavour to avoid making that mistake again. Now onto the code, I have done that, one small issue appears. It might be more clear if I tell you what I am look to achieve. I will be running through the column A and find if the cell is empty. if it is, then I need then to unlock(unprotect) the worksheet to the highlight the cell in question and then lock(protect) the sheet using the same password.
No that you have a better idea what I am trying to achieve, this is my current code:
Now I know this code very untidy and I am re-looking at it, but any advise?Please Login or Register to view this content.
Regards,
What's not working?
No for some unknown reason.
I can't test the code so what error messages are being seen, what is actually happening?
As far as I can establish it cycles through the code fine the first time but after that it doesn't go past
and throws backPlease Login or Register to view this content.
Run-time error '1004'
The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalisation.
Also tried to make "passB" the first option but the same outcome came out. It deffo stops after the first option.
Are you using the correct passwords?
Yep, there is only two passwords passA and passB
If the actual passwords are as you say then you need to add speech marks in the code
"PassA" & "PassB"
As you can see here I did add speech-marks. Hmm this is an interesting pickleRoy,
Apologies for the mistake I will endeavour to avoid making that mistake again. Now onto the code, I have done that, one small issue appears. It might be more clear if I tell you what I am look to achieve. I will be running through the column A and find if the cell is empty. if it is, then I need then to unlock(unprotect) the worksheet to the highlight the cell in question and then lock(protect) the sheet using the same password.
No that you have a better idea what I am trying to achieve, this is my current code:
Now I know this code very untidy and I am re-looking at it, but any advise?Please Login or Register to view this content.
Regards,
You don't have a resume statement, therefore everything after your first on error goto line is actually an error handler (i.e. the whole of the rest of your loop) and an error that occurs in an error handler will cause a run-time error. I would suggest you move the password but to a separate function - something like:
and then call that from your code like so:Please Login or Register to view this content.
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
This did the trick, never realised I didn't have a resume procedure in place. Learned something new. Thank you
Last edited by romperstomper; 07-27-2010 at 06:59 AM. Reason: No need to quote the whole post!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks