View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default

George,

"How is the direction of the cursor movement changed "
tools, options, edit, move selection after enter, change to what you want

"Is it possible to have page setup be applied to all sheets of a workbook"
With the sheet that has the correct settings active, right-click on the
sheet tab and select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode now all sheets have the same page settings!

"Is it possible for the Header to appear on page 1 of a sheet only"
here is some code by Ron de Bruin that will do it

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'will print the header on 1st page only
Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.CenterHeader = "Put Your Header Here"
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1
.CenterHeader = ""
ActiveWindow.SelectedSheets.PrintOut From:=2, To:=Totpage
End With
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"George Tung" <George wrote in message
...
How is the direction of the cursor movement changed in a group of

highlighted
cells when enter is pressed?
Is it possible to have page setup be applied to all sheets of a workbook?
Presently I have to setup each page individually.
Is it possible for the Header to appear on page 1 of a sheet only?
Presently it appears on every page of a sheet.