View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
jodleren jodleren is offline
external usenet poster
 
Posts: 49
Default Getting name of sheet

Hejsa

Function GetPageName()
* GetPageName = ActiveSheet.Name
End Function


But - when printing 6 pages, will they get their own name, or the
active sheets name?
Then I'll get 6 pages with the same name - not what I want

=GetPageName()

To print in landscape goto File Page Setup Landscape


yep, but is there an OnBeforePrint event, where I can force it?


Use the header/footer option in the Page Setu Menu (other tab) to create
headers on each page.


Can I force this too?

Med venlig hilsen
Sonnich