Instead of using the control key and clicking the mouse on each tab to print
multiple tabs, I would like to see a print checkbox on each tab. I would
also like to see the tab automatically printed in the heading for each sheet.
Say we had sheets with tab labels of Northeast, Southeast, Midwest,
Southwest, and Northwest. I envision checking the boxes only for the
regions to print, with the printouts showing the labels from each one of the
tabs. This would also document for other users, which sheets are currently
setup for printing.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

You can put the tab name in the header.

--
Regards;
Rob
------------------------------------------------------------------------
"seb" wrote in message
...
Instead of using the control key and clicking the mouse on each tab to print
multiple tabs, I would like to see a print checkbox on each tab. I would
also like to see the tab automatically printed in the heading for each sheet.
Say we had sheets with tab labels of Northeast, Southeast, Midwest,
Southwest, and Northwest. I envision checking the boxes only for the
regions to print, with the printouts showing the labels from each one of the
tabs. This would also document for other users, which sheets are currently
setup for printing.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup

"RWN" wrote:

You can put the tab name in the header.

--
Regards;
Rob
------------------------------------------------------------------------
"seb" wrote in message
...
Instead of using the control key and clicking the mouse on each tab to print
multiple tabs, I would like to see a print checkbox on each tab. I would
also like to see the tab automatically printed in the heading for each sheet.
Say we had sheets with tab labels of Northeast, Southeast, Midwest,
Southwest, and Northwest. I envision checking the boxes only for the
regions to print, with the printouts showing the labels from each one of the
tabs. This would also document for other users, which sheets are currently
setup for printing.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup


Hi Rob,

Thanks, but I do realize the option is available in the page setup under the
"header/footer" tab and is available for either headings or footings. My
reason for the check box is to give another reader the ability to easily see
which tabs are included for printing. Quite honestly, it is not very
noticeable when multiple tabs are selected in group mode, which can have some
"side effects" on your spreadsheet. If multiple tabs are selected, just
about any modification you make on one sheet will impact the other selected
sheets. For example, if sheet one and sheet three, are selected in group
mode, deleting rows 7 thru 12 on sheet one, will delete rows 7 thru 12 on
sheet three, but not sheet two. Our organization, has several novice Excel
users occasionally making this sort of error. Their response is almost
always, I didn't notice multiple tabs were highlighted (not to mention the
word "group" in the blue bar. My suggestion, is really just a convenience
enhancement that would accomplish two objectives. One, it would document for
another reader, which tabs are selected for printing. Secondly, it would
provide a convenient method to document which sheets have printed, by
automatically printing the tab label.