 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / April 2004Header across entire workbook
Hi there, Is there a way for a defined header to print across the entire workbook, not just the active sheet? Actually, I just found a way. Click on the first tab, shift click on the last tab (so all the tabs are selected within the workbook), define the Header. Is there a better method? > Hi there, > Is there a way for a defined header to print across the entire workbook, not > just the active sheet? I believe that would be the 'normal' way. If this header you are using is to be applied to more workbooks in future, then you could write a macro (or probably just use the macro recorder) to automate it. Paul C,  Signature> Actually, I just found a way. Click on the first tab, shift click on > the last tab (so all the tabs are selected within the workbook), [quoted text clipped - 3 lines] >> Is there a way for a defined header to print across the entire >> workbook, not just the active sheet? BP Other than using VBA code, there is no better or faster way. Below is a sample. Places the info into the right header. Sub Path_All_Sheets() Set wkbktodo = ActiveWorkbook For Each ws In wkbktodo.Worksheets ws.PageSetup.RightHeader = ActiveWorkbook.FullName & " " & Chr(13) _ & Application.UserName & " " & Date Next End Sub This will give you full path and name plus the UserName plus the date. Can be assigned to a Button or into a Before_Print Macro in each workbook. I keep it in MyMacros.XLA and have it attached to a Menu. Note: workbook must be saved once in order to have a Path. Gord Dibben Excel MVP >Actually, I just found a way. Click on the first tab, shift click on the >last tab (so all the tabs are selected within the workbook), define the [quoted text clipped - 4 lines] >not >> just the active sheet?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.