Results 1 to 14 of 14

Macro program printing

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2009
    Location
    glasgow
    MS-Off Ver
    Excel 2003
    Posts
    16

    Macro program printing

    Hello. Had lots of help to create this excel sheet with macros. Im a doctor that works in a dermatology department where we carry out lots of allergy tests. A number of years ago someone helped design the attached macros etc to allow staff to select the batch of allergy tests they want out of a huge list, and then print off the selected tests only. It works a real treat, but, for example, if you click the first batch of tests, in print preview (And final printed document) it always produces as extra black border line (presumably from the top of the next batch of tests)
    All very complicated but if you have a look at the document (with macros enabled) im hoping you'll get a feel for whats needed. If you can get rid of the extra black line id be delighted !
    I think I might have tried before but is there a way to automatically make a new page for printing at the end of each batch of tests (rather than splitting them over two pages)- currently having to use page break mode everytime and change where the page splits. If that could be automated it would be a dream !
    Sorry Im a real novice.
    Cheers
    Attached Files Attached Files
    Last edited by gw76; 02-02-2012 at 04:59 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1