+ Reply to Thread
Results 1 to 6 of 6

Printing

  1. #1
    Registered User
    Join Date
    08-28-2010
    Location
    Southampton, Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    5

    Printing

    Can anyone please help. I have a 10 sheet workbook that I would like to include a macro on each sheet to print the active sheet the number that I type into a cell. For example:- The cell above could have print number and if I type 5 then 5 sheets would print without having to go to file,print and type the number required. Then if I go to the next sheet I might need 15 printed. Is this possible because when I try to record a macro, the print buttons ect are greyed out. Any help would be thankfully received.

    Apachewar

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Printing

    Assume the number of pages is in A1

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-28-2010
    Location
    Southampton, Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Printing

    Thanks for that, it is in A24, But where I put that code is another matter. I thought it would be as easy as when I record a macro. Obviously I'm over my head. That's the trouble with being a 60 year old novice.

    Apachewar.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Printing

    You're two years older than me! We all have to start somewhere

    Copy the Excel VBA code
    Select the workbook in which you want to use the Excel VBA code
    Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
    Choose Insert | Module
    Where the cursor is flashing, choose Edit | Paste

    To run the Excel VBA code:
    Choose Tools | Macro | Macros
    Select a macro in the list, and click the Run button

    If you want to use a button then read this

  5. #5
    Registered User
    Join Date
    08-28-2010
    Location
    Southampton, Hampshire
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Printing

    Quote Originally Posted by royUK View Post
    You're two years older than me! We all have to start somewhere

    Copy the Excel VBA code
    Select the workbook in which you want to use the Excel VBA code
    Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
    Choose Insert | Module
    Where the cursor is flashing, choose Edit | Paste

    To run the Excel VBA code:
    Choose Tools | Macro | Macros
    Select a macro in the list, and click the Run button

    If you want to use a button then read this
    Thats great thanks, works a treat. You may be 2 years younger, but I bet you started a lot more years than I. But I am much appreciated of your input. Thank you.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Printing

    I started about 8 years ago

+ Reply to 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