Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi from italy.....
so sorry for my bad english...:) I try to explain what I search : I want that the code under work always , with all workbook (past and future) : Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim WS As Worksheet For Each WS In ActiveWorkbook.Worksheets WS.PageSetup.LeftHeader = ActiveWorkbook.FullName Next WS End Sub where to put it ??? but i search also the code for print some sheet (If I want) without the "header" simply push a botton on menu-bar. can you hel me ? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Why is the "zoom" option grayed out in "print preview?" | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Excel 2000 VBA ActiveWorkbook.FullName | Excel Programming | |||
What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming |