• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Navigation in a worksheet

C

Cellardoor

Member
Dear All good morning.

I have a workbook with several sheets and i need to navigate between them several times (or by clicking on each one or by links that i've created - and work fine)

Is there a macro that makes every sheet open in the same cell?

Click on sheet 1, it goes automatically for "A1". Open Sheet 35 - "A1"...and so on.

The main objetive is to always open a sheet on the top of it (Because they have to much extended information)

See my point?

Many thanks

Cellardoor
 
sans a macro you could use the Ctrl+pg up & Pg down buttons to switch sheets and the Ctrl+Home button to go to A1

So Ctrl + Pg Up then immidately Home (without letting go of Ctrl)

just a thought
 
@json that is to navigate the worksheets, but i think Cellardorr wants XL to go to cell "A1" on activate_sheet

Option1) CTRL+HOME brings you to A1
Option2) exploit Worksheet_Activate event...but you need to do that for EVERY worksheet
Code: 
Private Sub Worksheet_Activate()
Cells(1, 1).Select
End Sub
 
For the hyperlinks, i use this formula: =HYPERLINK("#'" & B13 & "'!A1"; "Open"), and works pretty fine. But for navigation, im still searching for a solution :)
 
1)ALT+F11 to open VBA editor
2)In the Proget Navigator (top left pane) click on you file and then double-click on one of the Sheets (say Sheet2)
3)paste the code there
4)switch to excel and select Sheet2, select any cell and then switch to another sheet
5)go back to Sheet2
 
iferror said:
@json that is to navigate the worksheets, but i think Cellardorr wants XL to go to cell "A1" on activate_sheet

Option1) CTRL+HOME brings you to A1
Option2) exploit Worksheet_Activate event...but you need to do that for EVERY worksheet
Code: 
Private Sub Worksheet_Activate()
Cells(1, 1).Select
End Sub
Click to expand...


...which is why i suggested the Ctrol+Home
 
I have something in the back of my brain...i sort of remember that something like this can be done! How do you do that??
 
Hi ,

This is an event procedure available in the ThisWorkbook section ; since this returns the name of the sheet that has been activated , it can be used to do whatever is required with the active sheet.

For instance , this code :
Code: 
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
            Cells(1, 1).Select
End Sub
Narayan
 
You must log in or register to reply here.
Back
Top