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