Position cursor on opening of spreadsheet

Larry

unread,

Jan 26, 2009, 9:33:01 AM1/26/09

to

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

unread,

Jan 26, 2009, 9:55:02 AM1/26/09

to

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

--
Hth

Kassie Kasselman
Change xxx to hotmail

Larry

unread,

Jan 27, 2009, 8:17:00 AM1/27/09

to

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

Kassie

unread,

Jan 27, 2009, 2:10:06 PM1/27/09

to

My pleasure Rick

kenpetkau

unread,

Nov 10, 2009, 10:10:09 PM11/10/09

to

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.
Larry

"Kassie" wrote:

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

Gord Dibben

unread,

Nov 11, 2009, 1:30:10 PM11/11/09

to

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