Forum Discussion

Daniel May's avatar
Daniel May
Copper Contributor
Jan 06, 2018

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 unprotect and unhide ribbon and menu buttons are greyed out.  I unshared the file thinking it was that but it did not change.  What do I do?

excel

3 Replies

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Jan 07, 2018
    Hi Daniel

    Did you try downloading the file to your Desktop, making the changes and uploading back to OneDrive?

    Cheers
    Damien
    • Daniel May's avatar
      Daniel May
      Copper Contributor
      Jan 07, 2018
      Thanks. Yes I tried that. Didn’t do the trick.
  • Mark Fitzgerald's avatar
    Mark Fitzgerald
    Iron Contributor
    Jan 06, 2018

    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.

Resources