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
Using the tab key to move from cell to cell. 0
ENTER skips unlocked cells 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
cannot tab to next unlocked cell 0
Locked Several Worksheets, allow format cells/select unlocked cell 2
Change states of some checkboxes from drop-down list? 5
How to change format protection default to unlocked? 2

Top