Getting cursor to go to specified cell on opening

L

lewisjohn78

I want users when opening a location to open with the cursor at a
specific spot rather than the last place I saved. Any ideas how?
 
D

Dave Peterson

Put something like this into a General module:

Option Explicit
sub auto_open()
application.goto thisworkbook.worksheets("Sheet99").range("a99"),scroll:=true
end sub

Change the worksheet name (I used Sheet99) and address (A99??) to what you need.

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top