Have cursor go to specific place when worksheet opens?

  • Thread starter Thread starter RJQMAN
  • Start date Start date
R

RJQMAN

Is there any way to make the cursor go to a specific cell every time
the user accesses that worksheet from a sheet tab?
 
hi
this is worksheet code. right click the tab then click view code.
in the left drop down above the code window, click and select worksheet.
the worksheet change event should default into the code window. delete it.
paste this.
Private Sub Worksheet_Activate()
Range("A1").Select 'Adjust to suit
End Sub

regards
FSt1
 
You must log in or register to reply here.

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

Similar Threads

Oversensitive touchpad on modern laptops 0
Go to another cell on another worksheet 2
COPY EXCEL 2007 9
Cursor to go to Specific cell 4
Hyperlink to move the cursor to the top of the frozen panes 3
Cursor has permanently changed to fat white plus sign and... 1
Bold rectangle cursor in VB Editor 3
My cursor always in selection mode,wat about other cursor option 1

Back
Top