Need Macro for moving to different sheets

Hi All,

I have a Excel Work book having 3 sheets, Sheet1 Sheet2 and Sheet3.
I have a macro which will do if we click on the button 2 in Sheet 1 it moves to sheet 2 and click on button 3 in sheet1 then to sheet 3.
And when we click on back button from sheet 2 and sheet 3 it will come back to sheet1.

What i need is i want to hide both 2 sheets (sheet 2 and sheet 3) once i click button 2 then sheet 2 should be vissible and like for button 3.
Again if i click back button from sheet 2 and sheet 3 should come back to sheet1 and both sheets 2 and 3 should go invisible.

Can anyone add to below macro so that it will work as above.

Please Login or Register  to view this content.

Aneesh M

Please Login or Register  to view this content.

You can use this as the base code to create a macro to goto any sheet, just change the name of the new macro and the highlighted target sheet reference. This macro would go into a normal code module (Insert > Module).

Yes, I just showed you how to do your first button in post #2. That macro would go on a button intended to activate a sheet called "Sheet2". I even highlighted the part of the code you would need to edit.

To create the code for your next button, copy the code, change the name, edit the sheet to the next target worksheet, then attach it to your second button.

Repeat ad nauseum.

On each of your target sheets, you would have a "back" button attached to a macro that does the exact same thing, it's just that the name of the macro will be different and the sheet name will point back to the main sheet.

It's remarkably simple. Once you have edited the code given above to work on your first button, it will be clearer.

That's a completely different creature. Worthy of it's own Q&A. Start a new thread with appropriate title and supporting descriptions of your working environment, sheet names, paths, etc. re: Creating buttons to switch from one workbook to another


Please select Thread Tools from menu above and set this topic to SOLVED.