+ Reply to Thread
Results 1 to 2 of 2

Printing too many copies problem

  1. #1
    Registered User
    Join Date
    05-12-2004
    Location
    Cheltenham, UK
    Posts
    11

    Printing too many copies problem

    Can anyone help with the following macro? I'm trying to get it to print one copy each of the worksheets "po", "copy" & "site copy" but for some reason I'm getting three copies of each.

    And when I manually go file>print in this file, the printer settings default to 3 copies. Where is it getting this setting from and how do I change it?

    Please Login or Register  to view this content.
    Last edited by girthhart; 10-09-2008 at 10:19 AM.

  2. #2
    Registered User
    Join Date
    05-12-2004
    Location
    Cheltenham, UK
    Posts
    11
    Sorry, ignore this post.

    I think I've worked it out in File>Page Setup>Options.

+ 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. Excel 2007 : Strange gridline problem
    By wiremonkey22 in forum Excel General
    Replies: 1
    Last Post: 05-12-2008, 10:48 AM
  2. solver problem
    By haka in forum Excel General
    Replies: 3
    Last Post: 11-01-2007, 12:02 PM
  3. Calendar Formula Problem
    By roadburner in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-07-2007, 06:36 PM
  4. Printing Problem: Any tips to reforma?
    By leaffan27 in forum Excel General
    Replies: 3
    Last Post: 01-19-2007, 02:33 PM
  5. Macro that copies results from formula cells but not the formula itself???
    By jermsalerms in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2006, 11:40 AM

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