I’ve seen some methods with Invoke VB.
but couldn’t let it work.
anybody having a good solution of this?
I want to unprotect my protected workbook sheet in excel
I’ve seen some methods with Invoke VB.
but couldn’t let it work.
anybody having a good solution of this?
I want to unprotect my protected workbook sheet in excel
Well you could automate the manual process of unprotecting a sheet in Excel using Hot Keys right?
Alt + R = Switches to Review Menu on the top ribbon
PS = Unprotect sheet (if sheet’s already locked with a password) or Protect Sheet (if current sheet is still unprotected)
Enter password in resulting dialog
Click OK to unlock worksheet.
Hope this helps.