Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to hide column headings & row numbers? | Excel Discussion (Misc queries) | |||
Hide Row and Column Headings | Excel Programming | |||
Group a range - closing the group does not hide the controls.... | Excel Programming | |||
How do you hide column and row headings in Excel? | Excel Worksheet Functions | |||
How to hide the column headings displayed by Excel at the left of. | Excel Discussion (Misc queries) |