Moving from one unlocked cell to another

R

Rich

Using Escel 2003, I have the sheet protected with the cells unlocked that I
want to insert information into. It moves from left to right and down. How
can I set which cell it will go to next and not have to go thru the normal
sequence when hitting enter?

Thanks,
 
H

HelpExcel.com

Rich,

You can use a sheet based event in VBA to set the movement.

Regards,
Eddie
HelpExcel.com
 
R

Rich

Eddie,

Sorry, I don't know what that is. I went to the link and it looks like they
want money to help. Can't anybody help me in this forum?

Thanks,
 

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

Excel 2003 Regarding Cell Protection 1
ENTER skips unlocked cells 3
Locked Several Worksheets, allow format cells/select unlocked cell 2
How to change format protection default to unlocked? 2
Is there a way to insert images into unlocked cells 1
How to specify order of moving to unlocked cells in a protected sh 1
Copy data from unlocked cells 3
Change states of some checkboxes from drop-down list? 5

Top