+ Reply to Thread
Results 1 to 2 of 2

how to create macro button to print a selected area of sheet2 from another sheet

  1. #1
    Registered User
    Join Date
    07-03-2015
    Location
    calcut
    MS-Off Ver
    2007
    Posts
    1

    how to create macro button to print a selected area of sheet2 from another sheet

    please help

    i had created a an excel contains 6 sheets
    then i can inserted a macro button to print page 2
    the button is on page 3

    like this

    Private Sub CommandButton1_Click()
    Dim myNum As Integer
    myNum = Application.InputBox("enter a sheet number")
    Worksheets(myNum).PrintOut
    End Sub

    while clicking on the button i always need to type print 2
    is there any other way to just print the selected area of the sheet 2



    i need help

  2. #2
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: how to create macro button to print a selected area of sheet2 from another sheet

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to print selected area
    By izlopez in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-20-2013, 01:11 PM
  2. Create a print macro that would automatically select print area?
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 35
    Last Post: 09-06-2005, 05:05 PM
  3. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  4. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  5. Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM

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