Create Button For Jump Between Sheets (Excel Tutorial)

Always I m trying to discover something new for Microsoft Excel, because what I am thinking about Excel is “The Creator or Developer of Excel don’t know its range of Usage” (don’t mind developers). Really every time when I try to find something for excel then I seen what are people working on excel and what I am doing on excel…. Mean I find myself nothing in excel. So before I have already discussed with you few Excel Tutorials now another tutorial with Video. In this I will guide you how can we make a button in Excel with the help of Macro to Jump Between sheets.

Excel Macro Jump Between Sheets

Check This Tutorial>> Making 3D Ball – Cristal Ball with Adobe Photoshop (Tutorial)

How to Create Macro to Jump Between Sheets in Excel.

Open Excel > Create A Button>

Create button in Excel

You have create a Button now Give it a simple Name as per your requirement>>

Jump Between Sheets in Excel

Now we have to Assign a Macro for this button> Right Click on Button and Click on Assign Macro

Assign Macro in MS Excel

Give a memorable Name for it and Click on New

Record a New Macro in Excel

After click on new button you screen will redirected to another Program Microsfot Visual Basic. I will tell later about it. Here we have to Inset a Command for Jump to Sheet2

Visual Basic in Excel

This is command you have to insert it between

Sub Jump2Sheet2()
         Sheets(“Sheet1”).Select << this is the command
End Sub

After this you must click on Run as per picture show above..
And Close the window of Visual Basic
You have all done.. Now Go back to Sheet1 and Click on that Button you will be automatically redirected to Sheet2 by clicking that button.
And for your practice you have to make another button with same procedure to Jump Back to Sheet1.

if this video is not working or Youtube is Blocked se this How to Unblock Youtube without any Software or Direct Link of Video 

Still so many tutorials are remaining. so don’t forget to Subscribe us by following network.


Share this post