PDA

View Full Version : [SOLVED] Unable to edit cells in excel



Liran-a
08-14-2005, 11:08 PM
Hello.

I am facing the following problem:

When working on a specific sheet and trying to edit the content of a specifict cell (by Double-Clicking it or by <F2> key), it's contect is being deleted.

I do perfom, by vba, some checks of this specific cell, but none of these checks delete it's content.

Do you have any idea why the content of the cell is being deleted when wishing to edit it?

Thank you.

Jacob Hilderbrand
08-14-2005, 11:18 PM
If you open the workbook and disable macros does the problem persist?

Liran-a
08-14-2005, 11:53 PM
Yes. I disabled the marcos of Excel startup and the problem persists.

However, I did pay attention to the following: this problem occurs only when the sheet is protected. When removing the protection, I am able to edit the problematic cell.

Jacob Hilderbrand
08-15-2005, 09:12 AM
I see. The cell protection is set to Unlocked and Hidden. Uncheck the box for Hidden and you will be able to edit the cell.

Format | Cells | Protection

Liran-a
08-15-2005, 09:59 PM
I see. The cell protection is set to Unlocked and Hidden. Uncheck the box for Hidden and you will be able to edit the cell.

Format | Cells | Protection

Thank you very much DRJ. It works.
:friends:

Ken Puls
08-15-2005, 10:06 PM
Hi Liran-a, and welcome to VBAX!

Did you know that you can mark your own threads solved here? Just see the note in my signature. I'll get this one for you! ;)