Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like file name to appear on all documents as a default.
I would like to set up a default where all Excel documents automatically show
the file name when printed. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like file name to appear on all documents as a default.
Add this code to the ThisWorbook code module
Dim WithEvents AppClass As Application Private Sub Appclass_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean) With Wb.ActiveSheet.PageSetup .LeftFooter = Wb.FullName End With End Sub Private Sub Workbook_Open() Set AppClass = Application End Sub -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Mrs. S" <Mrs. wrote in message ... I would like to set up a default where all Excel documents automatically show the file name when printed. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like file name to appear on all documents as a default.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
How do I set the default to "Open" or "New" for a template | Excel Discussion (Misc queries) | |||
Excel should open documents in the folder of the current file | Setting up and Configuration of Excel | |||
How do I change file/open/"files of type" to default to "all file. | Excel Discussion (Misc queries) | |||
cannot open documents as viruscan says problem file? | Excel Discussion (Misc queries) |