| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Print header change
I am printing a worksheet using
With Sheets("Sheet1) ' Code that messes around with the worksheet ' ' .PrintOut End With How can I change the print header before doing the .PrintOut? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Print header change
Try something like the following before the PrintOut method:
.PageSetup.CenterHeader = "whatever you want" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Hmmm..." wrote in message ... I am printing a worksheet using With Sheets("Sheet1) ' Code that messes around with the worksheet ' ' .PrintOut End With How can I change the print header before doing the .PrintOut? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Print header change
Hi,
You'll see how to set up all aspects of headers by recording a macro while you do manual manipulations with page setup. Try pasting a logo too while you are at that. :) hth Paul Użytkownik "Chip Pearson" napisał w wiadomości ... Try something like the following before the PrintOut method: .PageSetup.CenterHeader = "whatever you want" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Hmmm..." wrote in message ... I am printing a worksheet using With Sheets("Sheet1) ' Code that messes around with the worksheet ' ' .PrintOut End With How can I change the print header before doing the .PrintOut? Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
|
Print header change
btw:
if you do several changes to page setup, try disabling screen repainting by Application.ScreenUpdating = False (and then back to True :) Page setup tends to make screen flicker. hth Paul Użytkownik "Chip Pearson" napisał w wiadomości ... Try something like the following before the PrintOut method: .PageSetup.CenterHeader = "whatever you want" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Hmmm..." wrote in message ... I am printing a worksheet using With Sheets("Sheet1) ' Code that messes around with the worksheet ' ' .PrintOut End With How can I change the print header before doing the .PrintOut? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get the Right Header Number to change after every print? | Excel Discussion (Misc queries) | |||
| How to change the number in a header with each print? | Excel Discussion (Misc queries) | |||
| My header and footer show in print preview but don't print. | Excel Discussion (Misc queries) | |||
| use a range for a print header | Excel Discussion (Misc queries) | |||
| Print header | Excel Worksheet Functions | |||
Linear Mode
