Groupings

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

Having created some groups I want to be able to expand some, and contract
others.

I can create the groups in code fine, but can only either expand or contract
all groups.

If I use Record Macro and click on the little + signs it does not create any
code.

Any clues about how you do this.

many thanks

Rod

(Version Office XP)
 
Look at .OutlineLevel in VBA's help.


Having created some groups I want to be able to expand some, and contract
others.

I can create the groups in code fine, but can only either expand or contract
all groups.

If I use Record Macro and click on the little + signs it does not create any
code.

Any clues about how you do this.

many thanks

Rod

(Version Office XP)
Click to expand...
 

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

Grouping Cells with Macro 1
Protect sheet but still allow use of grouping 3
Collapsing groups in Macro 7
Open / Close Grouping through VBA 13
Referring to column or row grouping using VB 1
Expand and Collapse groups 1
Collapsing all groups 0
MS Access setting outlook reminders from a DAO recordset 0

Back
Top