Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 26th 11, 01:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2010
Posts: 99
Default All sheets in workbook have same rows to repeat at top

I want to repeat the same rows (Rows 1 to 3) from a worksheet say
Sheet1 when printing any sheet
of the workbook.
When I try to do that I cannot select multiple sheet at the same time.
I also tried to select all the sheets and then try with the printing
command.
This also didn't work. It appears that this is a sheet only property.
Is there a way around.
Thanks in advance.

  #2   Report Post  
Old June 26th 11, 04:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default All sheets in workbook have same rows to repeat at top

You need VBA to achieve this.

Sub test()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
'For Each ws In ActiveWindow.SelectedSheets
If ws.Type = xlWorksheet Then
ws.PageSetup.PrintTitleRows = "$1:$3"
End If
Next
End Sub

NOTE: this will select rows 1:3 of each Sheet, not rows 1:3 of Sheet1

I want to repeat the same rows (Rows 1 to 3) from a worksheet say
Sheet1 when printing any sheet


If you wanted 1:3 of Sheet1 to print on other sheets you would have to copy
those rows to each sheet.


Gord Dibben MS Excel MVP

On Sun, 26 Jun 2011 05:06:32 -0700 (PDT), Subodh wrote:


of the workbook.
When I try to do that I cannot select multiple sheet at the same time.
I also tried to select all the sheets and then try with the printing
command.
This also didn't work. It appears that this is a sheet only property.
Is there a way around.
Thanks in advance.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you insert rows into multiple sheets in a workbook? Marketing Queen Excel Discussion (Misc queries) 2 May 30th 06 05:33 PM
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? Dmitry Excel Worksheet Functions 6 March 29th 06 12:43 PM
VBA Code To have a macro repeat on all sheets in a workbook carl Excel Worksheet Functions 3 November 3rd 05 07:48 PM
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec unibaby Excel Discussion (Misc queries) 2 August 24th 05 04:29 PM
How can I delete similar rows in excel workbook with many sheets? JSchrader Excel Worksheet Functions 1 April 26th 05 06:40 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017