R
RayportingMonkey
OK Here's one... I have a personal macro I use to hide the headings certain
sheets that I must do data entry into, because screen realestate is at a
premium with the multiple windows I must use while processing some of them.
With that in mind I setup these worksheets with as little on-screen as
possible, such as turning off the headers while I do data entry.
Sub zz_HeadingToggle()
' Keyboard Shortcut: Ctrl+Shift+H
If TypeName(ActiveSheet) <> "Worksheet" Then Exit Sub
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End Sub
However, some of these sheets are setup with columns and/or rows that are
grouped. Even with headings turned off, there is a big chunk of realestate
dedicated to the settings that toggle between hiding and displaying those
groupings.
Is there a way I can suppress these group settings as well as the headings?
Thanks!
Ray
sheets that I must do data entry into, because screen realestate is at a
premium with the multiple windows I must use while processing some of them.
With that in mind I setup these worksheets with as little on-screen as
possible, such as turning off the headers while I do data entry.
Sub zz_HeadingToggle()
' Keyboard Shortcut: Ctrl+Shift+H
If TypeName(ActiveSheet) <> "Worksheet" Then Exit Sub
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End Sub
However, some of these sheets are setup with columns and/or rows that are
grouped. Even with headings turned off, there is a big chunk of realestate
dedicated to the settings that toggle between hiding and displaying those
groupings.
Is there a way I can suppress these group settings as well as the headings?
Thanks!
Ray