Position cursor on opening of spreadsheet

  • Thread starter Thread starter Larry
  • Start date Start date
L

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?
 
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
 
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
 
Back
Top