ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to show only one part of rowlevel 3??? (https://www.excelbanter.com/excel-programming/293697-re-how-show-only-one-part-rowlevel-3-a.html)

Anita[_4_]

How to show only one part of rowlevel 3???
 
Making myself a bit clearer, hopefully :-).
The rest of the excelsheet should show rowlevel 2, only the month we are in should be fully expanded (rowlevel 3).
Still hoping for help! Anit

----- Anita wrote: ----

I'me making a timeschedule for flexible workinghours. The user fills in the time and what he/she does during the day.
The schedule is grouped by months and has subtotals.
My problem is that I want the excelsheet to automatically open/show the part of the outline that shows the month of "today", not all rows as in code "ActiveSheet.Outline.ShowLevels RowLevels:=3".
Does anyone know if this is possible??



All times are GMT +1. The time now is 06:08 PM.

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