How to unprotect a sheet with ribbon hidden?

I have a game that I have written using Excel VBA that I haven't worked on for a while. I seem to have myself locked out of making any changes. I have the ribbon hidden, and the sheet protected with a password. When I try to enable the ribbon with ALT-F1, I get an error that I can't do that on a protected sheet, and it tells me how to unprotect it. But I can't do that without access to the ribbon functions. Any ideas on other ways to enable ribbon and/or unprotect the sheet? Thanks.

I think you'll find that is because Alt+F1 is the keyboard shortcut for adding a chart to a sheet, not enabling the ribbon.

BSB

You're right, BSB. Should be CNTL+F1 to hide/unhide. But... that keystroke does nothing in my situation. :-( Ribbon doesn't appear.

In that case I think it all comes down to how you have "hidden" the ribbon.

The two lines below will hide the ribbon to a different degree.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The first will just minimise it and allow the Ctrl+F1 to show it again.
The second will really hide it and Ctrl+F1 will not work to show it again.

If you've used the second one then you could set up a mini macro that switches it back on and assign a keyboard shortcut to that.

BSB

I found a way to work around my "locked out" problem. If I open a "normal" spreadsheet (no locking or hiding), but one that has some VBA code, I can then access the code for my "problem" sheet from there, and make changes. :-)

Sounds like a complicated workaround to me.
Perhaps some code on the workbook open event that says "is the current user the administrator for this file? if so, do you want to show all the ribbon options and whatnot?" might be better...?

Just a thought (from someone whose job involves managing hundreds of different Excel based tools with many thousands of users!)

BSB