+ Reply to Thread
Results 1 to 2 of 2

Excel Document locked and toolbar is hidden

Hybrid View

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    Hants
    MS-Off Ver
    Excel 2003
    Posts
    17

    Excel Document locked and toolbar is hidden

    Hello,

    I have a document that I need to unlock/access but the top toolbar/ribbon has been hidden and the sheet has been locked. Is there a hot key to bring up the box to enter the password to unlock the spreadsheet?

    Thanks,
    Matt

    EDIT*
    I've worked it out, there was some VBA hidding the ribbon, so when I activated macro security everything disappeared. I've edited the coding now so the toolbar shows up!
    Last edited by mparker123; 03-20-2015 at 11:08 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Excel Document locked and toolbar is hidden

    Hi there Try ALT and RPS

    It might ding after ALT and RP, but panic not, hit the S anyhow...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to VIEW hidden/custom XML in excel document??
    By excelsior215 in forum Excel General
    Replies: 0
    Last Post: 03-13-2013, 03:13 PM
  2. Paste disabled when toolbar is Hidden in Excel 2007
    By loknath in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-23-2012, 02:57 AM
  3. Locked Document Problem
    By Jaxinc in forum Excel General
    Replies: 2
    Last Post: 04-11-2011, 01:27 AM
  4. [SOLVED] How do I 'unlock' it when it says my document is locked?
    By sdl121 in forum Excel General
    Replies: 1
    Last Post: 04-25-2006, 09:10 PM
  5. choose Locked & Hidden :Hidden Cells
    By Khalil Handal in forum Excel General
    Replies: 2
    Last Post: 12-14-2005, 04:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1