Closed Thread
Results 1 to 6 of 6

opening sheet3 by button!

  1. 12-09-2009, 03:18 AM #1
    miyat
    miyat is offline
    Registered User
    Join Date
    12-01-2009
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    29

    opening sheet3 by button!

    hi guys, i can u help me come-up a code for this... i have a command button in sheet1, n i want to go directly to sheet3 with a command button to be click in sheet1... is it possible? tnx...
    Reply With QuoteRegister To Reply
  2. 12-09-2009, 03:25 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: opening sheet3 by button!

    Something like
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 12-09-2009, 10:11 AM #3
    scaffdog845
    scaffdog845 is offline
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    375

    Re: opening sheet3 by button! 

    Please Login or Register  to view this content.
    Will select sheet3 as the active sheet and make cell A1 the active cell
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.
    Reply With QuoteRegister To Reply
  4. 12-09-2009, 12:26 PM #4
    Jack in the UK
    Jack in the UK is offline
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: opening sheet3 by button! 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-09-2009, 02:15 PM #5
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: opening sheet3 by button!

    Add a hyperlink to a shape. no need for code.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  6. 12-09-2009, 03:03 PM #6
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: opening sheet3 by button!

    If you want to go to a specific cell, use

    Please Login or Register  to view this content.
    But I ould use Andy's hyperlink suggestion
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1