How to show only one part of rowlevel 3???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Only Copy Subtotals 8
Expanding the outline of one subtotal 1
Excel not showing steps as I F8 through each line of VBA code 1
Trying to "clean up" some code... 1
Taking the 51st Line and Multiplying by 2 8
Getting to the right worksheet 2
Can anybody get this code to perform on the correct worksheet? 7
Macro to show/hide detail in an outline 1

Back
Top