Position cursor on opening of spreadsheet

[Larry]

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?

 

[Kassie]

Select the cell you want selected on opening, save the file, and exit.

 

[Larry]

Thanks for response.
I will pass information on to user.
Larry

 

[Kassie]

My pleasure Rick

 

[Ken Petkau]

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:

RE: Position cursor on opening of spreadsheet
Thanks for response
I will pass information on to user
Larr

:

EggHeadCafe - Software Developer Portal of Choice
Programming C#
http://www.eggheadcafe.com/tutorials/aspnet/718b8580-cd75-4234-8764-db65bebbe8ad/programming-c.aspx

 

[Gord Dibben]

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