Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Making Worksheet Active With Macro

  1. #1
    Join Date
    12th May 2006
    Posts
    28

    Making Worksheet Active With Macro

    Basically trying to make change the active worksheet using a macro code. I want the user to be able to click a button and it will automatically switch the worksheet to another within the workbook. Any Ideas?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    6th May 2005
    Posts
    1,036

    Re: Making Worksheet Active With Macro

    Hi

    1) Where does the button come from? Forms toolbar, or control toolbox toolbar?

    2) Where is the button placed (what sheet)
    3) What is the name of the sheet you want to move to?

    Tony

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    12th May 2006
    Posts
    28

    Re: Making Worksheet Active With Macro

    The button comes from form toolbar. (However I am open to using the control toolbar if that is a better option.)

    The button is located currently (on top of cells d30,e30,f30,d31,e31,f31) [although it can be placed where ever)

    The current sheet that it is on is called "Shipments by Service Level" When clicked I would like for it to load "Shipments by Service Level 3"

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    6th May 2005
    Posts
    1,036

    Re: Making Worksheet Active With Macro

    Hi

    Build yourself a general module macro

    VB:
    Sub changesheets() 
        sheets("Shipments by Service Level 3").select 
    End Sub 
    
    
    Right click on the button, select assign macro, and assign the above macro.

    When pressed, it should take you to the nominated sheet.

    Tony

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    12th May 2006
    Posts
    28

    Re: Making Worksheet Active With Macro

    I am kind of new to all of this. Would you be able to give me a short step by step procedure to create this from the begining of creating the button to the entering of the macro code. I'd appreciate it.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    12th May 2006
    Posts
    28

    Re: Making Worksheet Active With Macro

    Nevermind I think I figured it out how to work it. Thanks alot.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Macro Code Only Works If Specific Worksheet Active
    By badger55 in forum EXCEL HELP
    Replies: 2
    Last Post: April 30th, 2008, 02:52
  2. Macro Code To Change Active Worksheet
    By pk230 in forum EXCEL HELP
    Replies: 4
    Last Post: May 13th, 2006, 02:48
  3. Making a macro unique to a worksheet
    By NealM in forum EXCEL HELP
    Replies: 8
    Last Post: February 6th, 2006, 19:20
  4. Replies: 6
    Last Post: June 28th, 2005, 09:30
  5. Making list boxes active on spreadsheet
    By Ranger in forum EXCEL HELP
    Replies: 2
    Last Post: February 21st, 2005, 21:23

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
  •  
porno