| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Setting the focus
Works fine thank you.
Orf JLatham wrote: This takes a few steps to get to work exactly the way you want it to. First, the coding part. Enter this into the Workbook code section using the Visual Basic Editor Option Explicit Private Sub Workbook_Open() Worksheets("Sheet1").Select Range("B65536").End(xlUp).Offset(1, 0).Select End Sub To get into the VB Editor, start by pressing [Alt]+[F11] then look at the Project window and double-click the entry in the 'tree' that says "This Workbook". If you don't see the Project window (left side of the screen, upper left 1/3rd of the screen) choose View | Project from the menu bar. This presumes that the first empty cell in column B will be at the end of a list of entries in that column, and that there are not empty cells within filled in cells in that column. If the sheet name you need to go to is something other than "Sheet1", change that, of course. To get your cursor to move from Left to Right across the sheet instead of top to bottom, go to Toos | Options and choose the [Edit] tab. Find the entry that says "Move Selection After Enter" and check the box next to it and change the direction from "Down" to "Right" Now that doesn't stop the cursor from stopping in cells in between the columns you want it to stop at. Here's how to "fix" that: Choose the columns where you do want the user to enter information into and then use Format | Cells and uncheck the box next to "Locked" on the [Protection] tab. You will want to do this for all columns that you want the user to be able to enter information into, as B, C, D, E, F, M, N and O. Go back to your worksheet and choose Tools | Protection | Protect Sheet and clear the checkbox next to the entry that says Select Locked Cells. Whether or not you assign a password as being required to unlock the sheet is up to you. Until you test it and make sure it works, I'd just leave it blank that way all you have to do is choose Tools | Protection | Unprotect Sheet to work in it some more. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File associate setting in Excel | Excel Discussion (Misc queries) | |||
| Excel 2003 Toolbar Icons are fuzzy and out of focus | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Threaded Mode
