Toggle Headings for All Worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rebecca - 30 Mar 2008 10:22 GMT

I am using MS Excel 2007. I have a workbook with many worksheets. Sometimes I
need to see the headings, sometimes not. Is it possible to turn on or off the
headings for ALL the worksheets simultaneously. Thanks.

Reply to this Message

Rebecca - 30 Mar 2008 10:25 GMT

Never mind. If I select all sheets by right-clicking on the tabs, then
checking or unchecking headings in Show/Hide, the headings are toggled, so
the problem is solved.

Just curious. Is there another way.

> I am using MS Excel 2007. I have a workbook with many worksheets. Sometimes I
> need to see the headings, sometimes not. Is it possible to turn on or off the
> headings for ALL the worksheets simultaneously. Thanks.

Reply to this Message

Dave - 30 Mar 2008 14:46 GMT

Hi Rebecca,
You could paste the following macro into your sheet and give it a
keyboard shortcut or a button. It turns headings of all sheets off if
they're on, and vice versa.

Sub DisplayHeadings()
A = ActiveSheet.Name
Sheets.Select
If ActiveWindow.DisplayHeadings = False Then _
ActiveWindow.DisplayHeadings = True Else _
ActiveWindow.DisplayHeadings = False
Sheets(A).Select
End Sub

Regards - Dave.

Reply to this Message

Rebecca - 30 Mar 2008 17:12 GMT

That sounds good. Thanks for the help, Dave.

> Hi Rebecca,
> You could paste the following macro into your sheet and give it a
[quoted text clipped - 11 lines]
>
> Regards - Dave.

Reply to this Message

Rate this thread: