• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

Unlocking an Excel spreadsheet for editing

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.
1 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

NormaPosyAuthor Commented:
Thank you.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now