ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide Headings / Group (https://www.excelbanter.com/excel-programming/400688-hide-headings-group.html)

RayportingMonkey

Hide Headings / Group
 
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


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com