Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: page setup in excel 2000

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Dave Cunningham
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In a workbook with multiple worksheets, I want to select all my worksheets and in the page setup, sheet tab, define the rows I want to print at the top of each page. Those options are grayed out unless I select each worksheet individually. Is there a fix for this problem?
    Thank you.
    Dave Cunningham

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dave,

    Here is a workaround: simply use the following macro to set the number of title rows for all the selected sheets at once.

    Sub MultiTitleRows()
    Dim TitleRows As Range
    Dim WS As Worksheet
    Set TitleRows = Application.InputBox( _
    "Enter title rows to be used for each selected worksheet", _
    "Multi-sheet Page Setup", Type:=8)
    For Each WS In ActiveWindow.SelectedSheets
    WS.PageSetup.PrintTitleRows = TitleRows.Address
    Next WS
    End Sub
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •