How could it be?

  • Thread starter Thread starter GCF
  • Start date Start date
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How could it be? 1
How to specify order of moving to unlocked cells in a protected sh 1
ENTER skips unlocked cells 3
Can I get excel to automatically fill color to all unlocked cells? 3
Excel 2000 help please - Cell protection 2
VB Coding 1
VBA code and protected cells 9
Forms Checkbox & Protection - Excel 2003 2

Back
Top