Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Making Worksheet Active With Macro

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    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

    Comment


    • #3
      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"

      Comment


      • #4
        Re: Making Worksheet Active With Macro

        Hi

        Build yourself a general module macro

        Code:
        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

        Comment


        • #5
          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.

          Comment


          • #6
            Re: Making Worksheet Active With Macro

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

            Comment

            Trending

            Collapse

            There are no results that meet this criteria.

            Working...
            X