How could it be?

G

GCF

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

Thany yo
 
D

Dave Peterson

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

Thany you
Click to expand...
 

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
problem in protecting excel worksheet 3
How to specify order of moving to unlocked cells in a protected sh 1
Excel VBA programming assistance 2 PART CHALLENGE 1
Home key behavior question 2
Hi-Lite "empty" unlocked cells in non-hidden rows 4
Excel 2003 VBA - Select a range based on a date 1
Excel 2003 VBA Assistance needed 5

Top