| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide columns in a group on after VBA-procedure
Hello!
A bit of help needed please... On a reporting-sheet, I have selected some columns (F:J) and made them into a group (using menus DATA-GROUP). Now the user can select whether to view these columns by clicking the '+' symbol, and hide them again by clicking the '-' symbol. Now, the report is built by a VBA-procedure when the user clicks a 'Build Report' button. I would like the the group to be hidden by default after the report is built. The way it is now, the group is in the state the user left it before building the report. How do I add a line in the procedure so that the group/columns are hidden? Regards, -NorTor- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide columns in a group on after VBA-procedure
Worksheets("Sheet2").Outline _
.ShowLevels columnLevels:=1 -- Regards, Tom Ogilvy "NorTor" wrote in message ... Hello! A bit of help needed please... On a reporting-sheet, I have selected some columns (F:J) and made them into a group (using menus DATA-GROUP). Now the user can select whether to view these columns by clicking the '+' symbol, and hide them again by clicking the '-' symbol. Now, the report is built by a VBA-procedure when the user clicks a 'Build Report' button. I would like the the group to be hidden by default after the report is built. The way it is now, the group is in the state the user left it before building the report. How do I add a line in the procedure so that the group/columns are hidden? Regards, -NorTor- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide columns in a group on after VBA-procedure
Thank you so much Tom, just what I needed!
Regards, NorTor On Tue, 28 Jun 2005 09:28:20 -0400, "Tom Ogilvy" wrote: Worksheets("Sheet2").Outline _ .ShowLevels columnLevels:=1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Chart When Row Group Closed | Charts and Charting in Excel | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| Hide/Unhide vs Group/Ungroup - Need Help | Excel Discussion (Misc queries) | |||
| Automatic Hide group of a columns based on cel value | Excel Discussion (Misc queries) | |||
| Is there a simple procedure to hide rows if a condition is met | Excel Discussion (Misc queries) | |||
![NorTor[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
