I have a workbook that has been password protected and has sheets that are hidden in it. We need to unprotect the workbook so we can access the hidden sheets but my coworker who created the book can't remember the password used to protect the book.
Does anybody have a macro that can assist with unprotecting the workbook so we don't lose the data saved within the hidden sheets if we are missing the password used to protect.
Does anybody have a macro that can assist with unprotecting the workbook so we don't lose the data saved within the hidden sheets if we are missing the password used to protect.