How could it be?

G

GCF

How could it be? After I design a spreadsheet, I did a “Format Cells
and locked all of them, and then went back and unlock all cells to b
used for data entry. When I used the left, or right, arrow keys withi
the unlocked data entry area all worked well. When I hit the end of th
unlocked area, or tried to use the up or down arrow to navigate, I wen
to 99% CPU usage and EXCEL stops responding. It may be something I di
in VBA, which I know very little about, when I was playing wit
“OnTime”.

Thank yo
 
D

Dave Peterson

Close excel (to kill any .ontime procedures).

Reopen excel
File|open your workbook
but disable macros.

Clean up any of that ontime stuff that you were playing with (as long as you
don't need it).

Save the workbook
close the workbook
reopen it (with macros enabled if you need it)

Did that help.

===
If it didn't, were you playing with any _selectionchange events?
 
Top