Removing protections that prevent me from editing formulas.

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I am trying to modify an Excel Workbook that I received from my company. When
I try to change formulas in the workbook I get the following error: "The cell
you are trying to type into contains a formula and should not be edited." The
workbook prevents me from editing any of its formulas. I thought the problem
might be that the workbook is protected, but it is not.
 
Tom, somebody has probably protected a specific range of cells with a
password: the whole Workbook itself does not have to be protected.
 
That doesn't sound like one of Excel's "canned" error messages, so I suspect
that there is some worksheet or workbook code behind it all. Select that
sheet and right-click on its name tab and choose [View Code] from the list
and see if there's any code associated with the sheet. If you don't see any,
try and Edit--Find from within the VB Editor for part of the phrase such as
"should not be edited" and choose to search the entire VBA project.
I also suspect that the worksheet is protected, and probably with a
password, so just finding the code may only be the first step in making
alterations to it. Just keep in mind that the originator of the workbook
probably had some reason to try to keep you from altering the formulas in it
.... so be sure you are walking down a path you really want to go down.
 
Back
Top