Simple macro to hide and show detail - Grouped Rows

[John]

Im sure this should be simple however I cant find the answer:

I have a spreadsheet that has been developed for a number of users.
The spreadsheet is protected however I want to alow the users to show
and hide grouped rows without unprotecting the worksheet. There dosnt
appear to be an option to allow this when protecting the sheet.

So i decided to create a simple macro that unprotects the worksheet
selects the appropriate cell then expands the grouping to show the
detail then re protects the worksheet.

If I record the macro the show detail part of the process is not
recorded. Can anyone tell me what the VBA code is to show and hide
detail.

 

[Vergel Adriano]

Try setting the ShowDetail property to True or False...

something like this if it's grouped by rows:

ActiveSheet.Range("A1").EntireRow.ShowDetail = False