Forum Discussion
sbates421
Nov 03, 2019Copper Contributor
copying worksheet
I used to be able to right click on a tab and select copy and it would duplicate the exact same information onto a new tab. Now I'm unable to do it - what
- Nov 04, 2019
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
SergeiBaklan
Nov 04, 2019Diamond Contributor
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
1441engraving
Jul 28, 2020Copper Contributor
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?
- SergeiBaklanJul 28, 2020Diamond Contributor
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