Unlocking an Excel spreadsheet for editing

Posted on 2014-07-14
Last Modified: 2014-07-17
Some years back I created a VB6 application. It generates a number of Excel spreadsheets.

At that time, with help here, I learned how to terminate the VB6 creation of a .xls file in a way that allows manual editing after the fact. Apparently I overlooked one of them. I really don't want to resurrect my old XP machine, invoke VB6 , and fix this that way.

Question: How do I unlock a spreadsheet so I can manually change something in it?
I'm talking about a .xls not a .xlsx file. And I can use my old XP machine if necessary. (I'm running Win 7 now).

Please note: I'm having surgery tomorrow, so likely won't get back here for a few days. Would appreciate help waiting for me when I return.
Question by:NormaPosy
    LVL 100

    Accepted Solution

    Is the sheet opening and giving a warning to enable editing or do you have the cells locked.

    In Excel 2010
    In the HOME Ribbon
    CLick FORMAT icon
    You should have options to UNPROTECT SHEET if the sheet itself is protected and to lock or unlock cells


    Author Closing Comment

    Thank you.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now