When a file opens always opens on the first tab titled “Home”

[Rebeca Zepeda]

HOLA, I BUILD A DASHBOARD THAT HAS A MENU (TAB TTITLED HOME), FROM HERE I HAVE A LINK TO TABS ;DASHBOARD, IN THE DASHBOARD YOU CLICK A GRAPH AND IT TAKES TO TO CHART 1 OR CHART 2 DEPENDING ON YOUR SELECTION . HOW CAN I MAKE THE HOME TAB THE ONE THAT OPENS WHEN YOU OPEN THE FILE ?,

ALSO ....HOW MUCH YOU CHARGE ME TO GO TROUGH THE FILE AND MAKE SUGGESTIONS;

TABS;

HOME = MENU

DASHBOARD =ALL GRAPHICS

CHART 1

CHART 2

CHART 3

CHART 4

CHART 5

INPUT 1

INPUT 2

INPUT 3

INPUT 4

INPUT 5

 

[Hui]

Rebeca


Copy the code below into the ThisWorkbook Module in VBA


Save the file as a *.xlsm file type

[pre]

Private Sub Workbook_Open()
Sheets("Home").Select
Range("A1").Select
End Sub

[/pre]

 

[Rebeca Zepeda]

Great ,Thank you very much,


What about the estimate cost to validate the dashboard as mentioned above all those tabs?