Forum Discussion
Daniel May
Jan 06, 2018Copper Contributor
Cannot Unprotect a workbook or sheets
I protected my xlsx file with multiple sheets and saved it to my One Drive. I then shared this file with a couple others in my office and now I can no longer unprotect or view hidden sheets. The un...
Mark Fitzgerald
Jan 06, 2018Iron Contributor
Could someone have applied a Custom UI part to your file? I've used this strategy to disable the Defined Names part of the Formulas ribbon tab to remove visibility of named ranges in distributed workbooks.
Try Googling "Custom UI Editor" and you will find free downloads of applications that make it easy to see and edit Custom UI parts in your workbooks.
You can also edit the UI parts by renaming a copy of your workbook as a .zip file and opening that to see if it contains any Custom UI.