Position cursor on opening of spreadsheet


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?
 
Ad

Advertisements

K

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
 
Ad

Advertisements

G

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top