View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chrigu Chrigu is offline
external usenet poster
 
Posts: 1
Default PageSetup doesn't work

I checkt the code, everything works when i check with F8. But the
Header is not changed...

dim wks as worksheet
for each wks in thisworkbook.worksheets
wks.PageSetup.RightHeader = "HeaderRight"
next wks

Thanks for your help!