+ Reply to Thread
Results 1 to 1 of 1

set print area based on selection

  1. #1
    Registered User
    Join Date
    12-03-2004
    Posts
    4

    set print area based on selection

    Hi

    I would like to print out 2 pages , the first one is always the same
    but the second one depends on the choice you make in the first one
    I have 5 "levels" to choose out when you choose one of the "levels"
    the matching second page should also be printed out when you click print
    ( I know it has something to do with page set up print area , but somehow i can' t create the macro to switch between levels and printareas)
    the second, tirth, fourth,...pages are beneath the first one

    the levels are "powered on" by a checkbox that gives a true/false value in cell H12 going to L12
    e.g. when i click the checkbox for level 2 the cell I12 gives the value True
    and then the print area should give the first page +printarea for the second page

    PS: when you disactivate all the checkboxes only the first page should be printed
    Attached Files Attached Files

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1