Forum Discussion
copying worksheet
Please check File->Info of your workbook, sheets and workbook structure are protected. To unprotect click on
and enter password with which the workbook was protected
Please check File->Info of your workbook, sheets and workbook structure are protected. To unprotect click on
and enter password with which the workbook was protected
Thanks for your answer. That's exactly what I was looking for.
There's one problem. I don't know the password because the person who made this document doesn't work at my office anymore.
Do you know how to fix this?
Nope, the only way I know is to find that person and ask him/her password.
I've tried the Review>Unprotect doc with no results. I then tried your technique of going to File>Info>Unprotect... still didn't work, even after I saved it, closed it, and reopened it. Any other thoughts?
If only structure is protected it shall work. Same from this menu
If workbook is encrypted with password protection, when Save As and here in Tools, General options remove password before saving
