Results 1 to 8 of 8

Command Button control of Sheet selection

Threaded View

macky1730 Command Button control of... 04-13-2009, 02:41 AM
JBeaucaire Re: Help from the Experts... 04-13-2009, 02:49 AM
macky1730 Re: Help from the Experts... 04-13-2009, 02:58 AM
macky1730 Re: Help from the Experts... 04-13-2009, 02:53 AM
macky1730 Re: Help from the Experts... 04-13-2009, 02:55 AM
royUK Re: Help from the Experts... 04-13-2009, 03:36 AM
macky1730 Re: Help from the Experts... 04-13-2009, 04:21 AM
JBeaucaire Re: [Solved]Command Button... 04-13-2009, 05:16 AM
  1. 04-13-2009, 02:41 AM #1
    macky1730 is offline
    Registered User
    Join Date
    04-13-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    94

    Command Button control of Sheet selection

    I would like to know how to configure buttons:

    In tab Sheet1 there is Commandbuttons named "Sheet2" & "Sheet3". If i press "Sheet2" then i will be directed to sheet2 tab, same as "Sheet3". In tab Sheet2 & Sheet3 there is commandbutton "Sheet1", if i press the button then i will be directed to default tab which is sheet1. Please show me how to do it. Thanks

    P.S. : I would also like to make the Tabs Sheet2 & Sheet3 to be hidden if its possible

    Update: I've played around from other posts here and i've come up with this simple and can be functional for me someday thanks for people who helped.. try2.xls was my output
    Attached Files Attached Files
    Last edited by NBVC; 04-13-2009 at 07:44 AM.
    Reply With QuoteRegister To Reply
« 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