View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RayportingMonkey RayportingMonkey is offline
external usenet poster
 
Posts: 87
Default 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