Lindsey

"Arrow inside and remains in view".

Sounds like a ComboBox from the Control Toolbox Toolbar.

Not a Data Validation dropdown.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 12:24:01 -0800, "lindsey"
wrote:

thank you so much. i have another question. on a drop down box, is there
anyway for the arrow to be "inside" the cell with the drop down list and also
for the arrow to be seen? some guy before me created this worksheet and it
has drop down boxes where you can see the arrow and it's inside the cell.
when i create my drop down box, the arrow only shows up when you get to that
cell and it is outside of the cell. i hope this made since

"Gord Dibben" wrote:

Lindsey

Right-click on the Excel Icon left of the File command on menu(assuming your
window is maximized) and "View Code"

If window not maximized r-click on the logo in title bar.

Copy/paste this into that module.

Private Sub Workbook_Open()
Sheets("Sheet1").Select
Range("A1").Select
End Sub

Edit to your sheet name and range.

Save and close workbook. Re-open.


Gord Dibben Excel MVP

On Tue, 13 Dec 2005 13:42:20 -0800, "lindsey"
wrote:

when i open a spreadsheet that i created, how do i get the cursor to go to
the cell i want it to.. in this spreadsheet i will have to enter information
in different columns and i want it to automatically go to the first cell
under the first column. how can i do this?