| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving from one unlocked cell to another
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Movement
Rich,
You can use a sheet based event in VBA to accomplish this. Regards, Eddie http://www.HelpExcel.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Movement
Rich,
You can use a sheet based event in VBA to set the movement. Regards, Eddie HelpExcel.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Movement
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, "HelpExcel.com" wrote: Rich, You can use a sheet based event in VBA to accomplish this. Regards, Eddie http://www.HelpExcel.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot tab to next unlocked cell | Excel Discussion (Misc queries) | |||
| open worksheet on first unlocked cell | Excel Discussion (Misc queries) | |||
| How was user able to (accidentally) change an unlocked cell to loc | Excel Worksheet Functions | |||
| Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
