ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I cannot edit in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/45636-i-cannot-edit-cell.html)

Kelli

I cannot edit in a cell
 
I have the " allow edit in cell" box cheked inder toolos - options, but when
I double click in a cell I do not get a cursor. All the other spreadsheets in
the workbook are ok. The sheet is not protected.

David McRitchie

Hi Kelli,
Are you saying that the cursor completely disappears?

Perhaps the cursor changed to another form.
http://www.mvps.org/dmcritchie/icons/pointers.jpg

If it disappears, when does it come back?

Look in the name box to the left of the formula bar, is the cell
shown there visible.

Right click on the sheettab, view code, are there any code there
other than the Option Explicit

If you have been working with event macros possibly or addins,

In the VBE, type the following into the Immediate Window (Ctrl+G)
?application.Cursor

The default cursor would show up as -4143

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kelli" wrote in message ...
I have the " allow edit in cell" box cheked inder toolos - options, but when
I double click in a cell I do not get a cursor. All the other spreadsheets in
the workbook are ok. The sheet is not protected.





All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com