Manually Unprotecting a pre-protected Macro Enabled file.
Hi Friends,
I am exercising Macro coding in my home and have faced an issue. I have protected the worksheet with a blank password, but unable to unprotect the worksheet manually. Can anybody help me to solve this???
All sorts of solutions and suggestions are most welcome.
Regards,
Apurv
If the password is "blank", you shouldn't need to input a password when you unprotect the sheet. But there's no message to say it is then unprotected.
Or maybe you have used one or two spaces instead of a null string?
Suggest you post the code you used to protect the sheet.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
open the sheet in protected mode.
then- save as - find folder, then hit the tools button(beside the save button in the popup)- general options - security
should work for this application hopefully.
Hi TMShucks,
Below is the macro code which I have used in the sheet with an Option Button.
Public Sub OptionButton1_Click()
ActiveSheet.Unprotect Password = ""
Columns("F:AN").Select
Selection.EntireColumn.Hidden = True
Columns("E").Select
Selection.EntireColumn.Hidden = False
Range("C11").Select
ActiveSheet.Protect Password = ""
End Sub
After saving the file, once i re-opened it and tried to un-protect the sheet manually but the same didn't happen, giving me the error as "The Password you supplied is not correct".
@miko.sims: workbook protection on save is nothing to do with worksheet protection.
Hi miko,
Thanks for your suggestion. But please not that the file has been saved without any password and it is opening as well. I am facing issue in unprotecting the sheet. I have given the macro code which I am using for protecting the sheet.
Rgrds,
Apurv
Hi miko,
Thanks for your suggestion. But please not that the file has been saved without any password and it is opening as well. I am facing issue in unprotecting the sheet. I have given the macro code which I am using for protecting the sheet.
Rgrds,
Apurv
Please Login or Register to view this content.
Regards, TMS
Hi TMS,
Thanks for your valuable help. The coding helped me a lot. However there was a minor addition from my end. Giving here the exact code that helped me a lot.
Thanks Once Again.
Regards,
Andy.
Public Sub OptionButton1_Click()
ActiveSheet.Unprotect Password:=""
Columns("F:AN").EntireColumn.Hidden = True
Columns("E").EntireColumn.Hidden = False
Range("C11").Select
ActiveSheet.Protect Password:=""
End Sub
To be fair, I just copied and modified your code. I caught the first missing colon (
But, you're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks