Results 1 to 8 of 8

Need Macro for moving to different sheets

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    dubai
    MS-Off Ver
    Excel 2007
    Posts
    11

    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.
    Sub goto_sheet()
       Sheets("sheet1").Select
    End Sub
    Sub back_to_sheet()
       Sheets("sheet2").Select
    End Sub
    
    
    Option Explicit
    
    Sub naar_tabblad()
       Sheets("vul hier naam van het tabblad in ").Select
    End Sub
    Aneesh M
    Last edited by arlu1201; 04-23-2012 at 09:53 AM. Reason: Please put code tags in future.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1