Cannot be done without using code.

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

Pasted into Thisworkbook module.


Gord Dibben MS Excel MVP


On Tue, 10 Nov 2009 19:10:09 -0800, Ken Petkau wrote:

I'd also like to be able to position the cursor in a specific cell whenever I open an Excel Workbook. Any ideas? Thanks for the help.



Larr wrote:

Position cursor on opening of spreadsheet
26-Jan-09

to do this I have a user that needs the ability to position the cursor to a
particular cell when selecting a spreadsheet. On one sheet it may be K3 on
another it may be B7. Is there a way to set an option without using code?

Previous Posts In This Thread:

On January 26, 2009 9:33 AM
Larr wrote:

Position cursor on opening of spreadsheet
to do this I have a user that needs the ability to position the cursor to a
particular cell when selecting a spreadsheet. On one sheet it may be K3 on
another it may be B7. Is there a way to set an option without using code?

On January 27, 2009 8:17 AM
Larr wrote:

Position cursor on opening of spreadsheet
Thanks for response.
I will pass information on to user.
Larry

"Kassie" wrote:

EggHeadCafe - Software Developer Portal of Choice
Programming C#
http://www.eggheadcafe.com/tutorials...ramming-c.aspx