Hello,
Not sure if it's possible but can each sheet have a set cursor cell when opening them?
Thank you for any help or advice
Hello,
Not sure if it's possible but can each sheet have a set cursor cell when opening them?
Thank you for any help or advice
You could probably use a VBA Worksheet Activate event handler to do that. However, you should be aware that it might mean that you can't copy and paste between sheets.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Using VBA
Private Sub Worksheet_Activate()
' set cursor to cell B3
Range("B3").Select
End Sub
Okay let's say I want cell b2 on sheet1, cell a1 on sheet2, and cell c11 on sheet3 to be where the cursor is when opening those sheets.
Is it possible using vba?
ALT + F11 to go to vba editor
double click Sheet1 and paste the code
Private Sub Worksheet_Activate()
Range("B2").Select
End Sub
double click Sheet2 and paste the code
Private Sub Worksheet_Activate()
Range("A1").Select
End Sub
double click Sheet3 and paste the code
Private Sub Worksheet_Activate()
Range("C11").Select
End Sub
Excellent thank you so very much.
I'm glad to have helped.
Thanks for the fedback.
To save editing all the sheets:
' ALT + F11 to go to VBA editor
' double click ThisWorkbook and paste the code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks