Unable to edit cells in excel
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.
If you open the workbook and disable macros does the problem persist?
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.
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.Originally Posted by DRJ
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!
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Posting Permissions
Reply With Quote
