+ Reply to Thread
Results 1 to 2 of 2

automatically print a cover page before printing other sheets

  1. #1
    Registered User
    Join Date
    05-07-2024
    Location
    Belgium
    MS-Off Ver
    Microsoft 365
    Posts
    1

    automatically print a cover page before printing other sheets

    I'm looking for a way to automatically print a cover page before printing other sheets in Excel.

    (the Cover page in question will contain all the info for the rest of the workbook via e.g. '=sheet!A1' and floating illustrations.)

    Currently, I have a dedicated cover page tab in my workbook that I want to print first every time I click 'Print.'
    However, I haven't been able to find a built-in option within Excel to accomplish this.
    I've explored using VBA scripts, but they require manual execution each time, which isn't ideal.
    Because multiple user with very limited excel experience will be using this file.

    Does anyone have any suggestions, alternative approaches, or insights on how to achieve this seamlessly and automatically?

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,930

    Re: automatically print a cover page before printing other sheets

    Maybe you can use the BeforePrint event to intercept the print action and print the cover beforehand.


    In ThisWorkbook:

    Please Login or Register  to view this content.
    Last edited by ByteMarks; 05-07-2024 at 09:47 AM.

+ 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. Print blank page between page 1 and 2 on macro printing
    By zaphe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2015, 11:57 AM
  2. Automatically Printing rows 1-5, then 6-10 etc. per page
    By shane1800 in forum Excel General
    Replies: 7
    Last Post: 11-17-2013, 06:15 PM
  3. print page totals in every page automatically
    By asokaw in forum Excel General
    Replies: 2
    Last Post: 05-19-2013, 03:51 PM
  4. Hide Column & Print page Macro printing blank page?!
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 03:59 PM
  5. Printing Issue - Fit to Print 1 Page Wide
    By mdalby in forum Excel General
    Replies: 2
    Last Post: 02-13-2007, 02:07 PM
  6. Replies: 3
    Last Post: 03-08-2006, 08:30 PM
  7. Replies: 4
    Last Post: 02-17-2006, 08:36 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