add a check box on Excel tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

seb - 18 Oct 2005 20:18 GMT

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.

Reply to this Message

RWN - 19 Oct 2005 05:33 GMT

You can put the tab name in the header.

Signature

Regards;
Rob
------------------------------------------------------------------------

> 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
[quoted text clipped - 11 lines]
> 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/community/en-us/default.mspx?mid=ea13bcb2-e0ad-4
f46-9f61-c57e0b71df36&dg=microsoft.public.excel.setup

Reply to this Message

seb - 19 Oct 2005 14:51 GMT

> You can put the tab name in the header.
>
[quoted text clipped - 17 lines]
>
> 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.

Reply to this Message