Copying Worksheet Formatting (Rows to Repeat at Top)

L

Lilbit

Linking my worksheets, I have been able to get the worksheets after th
first worksheet to copy all the formatting of the first worksheet (
simply clicked on File, Page Setup, Ok). However, I cannot get the Row
to Repeat at Top specs of the first worksheet to copy to the other linke
worksheets. The top portion of the Sheet tab is grayed out when th
worksheets are linked. Do I have to add a code to the first worksheet?
If yes, what code? I'm using Excel 2000. Help!!! Thanks!!

-
Message posted using http://www.talkaboutsoftware.com/group/microsoft.public.excel.programming
More information at http://www.talkaboutsoftware.com/faq.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indicating Rows to Repeat At Top on all Worksheets Simultaneously 3
Excel crashes and restarts when accessing newly created worksheet 2
Forcing a User to Input a Specific Number of Characters 3
Copying worksheet from hidden instance of Excel 1
Copying a differing range of rows to a new worksheet 2
move data from one spreadsheet to another and repeat 1
Copying worksheet A values into worksheet B - missing cell values 16
Rows to repeat at top 3

Top