+ Reply to Thread
Results 1 to 3 of 3

Macro Print 8 Worksheets

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2010
    Posts
    1

    Macro Print 8 Worksheets

    Dear All,

    I'm a new member. This letter become my introduction and also rising my question.

    I use Excel 2007 and 2010.

    My problem:
    1. I want to make a macro button to print selected worksheets. How to do it?
    2. I want to make a macro button that can run "SOLVER" in one click. How to do it?

    I try macro record to make print preview, but when I open print preview, I can't stop the recording.
    I have try using macro record for SOLVER, but it doesn't run.

    Your answer and assistance really appreciated and helpful for me.

    Best,

    Ai

  2. #2
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Macro Print 8 Worksheets

    put this code in This Workbook and change the sheets that you want to print. Create a button and assign the macros to it
    Please Login or Register  to view this content.
    this is for print only

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro Print 8 Worksheets

    I have try using macro record for SOLVER, but it doesn't run.
    Before you can use a macro to run Solver you need to set a reference to Solver in the "Microsoft Visual Basic" window.

    Go to Tools -> References and tick box for Solver. See pgn files "Reference_setting1" and "Reference_setting2"

    If Solver not found you must browse for it. File is named "Solver.xlam" and is usually found in folder:

    "C:\Program Files\Microsoft Office\Office14\Library\Solver\Solver.xlam"

    As browser by default is set up to find library files change setting to "All files (*.*)"

    Alf
    Attached Images Attached Images
    Last edited by Alf; 05-27-2013 at 06:58 AM. Reason: Uploading files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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