Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Question Unanswered: How to Unlock Excel workbook

    Hi everybody,

    I received a workbook which has been locked, not only locked, but TOTALLY locked.

    - The menu is locked, I couldn't insert any rows.
    - In the VBA editor, I couldn't even see the worksheet names, all the worksheets have been hidden.
    - In the VBA editor, I couldn't even insert a module.

    Can any Excel expert advise me how to unlock the workbook please ?
    Thank you very much.

    Lepanto

  2. #2
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1
    Hi Lepanto,

    Right click on file->Properties->Unchecked block option
    Last edited by addisionphilip; 04-11-16 at 02:21. Reason: Old Post

Posting Permissions

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