Any way to react on grouping sheets?
 

Hi.

If the user selects muliple sheets using Ctrl+Klick, no event is being
raised - or I missed it.
But if the user does so I would like to disable some of my own
command-buttons.
Is there any change on reacting on grouping sheets?
Excel itself does this - look at the icon for creating charts - but does not
provide any event here :-/

Michi

Any way to react on grouping sheets?
 

To the best of my knowledge, I can't see an event that is activated by
grouping sheets if you don't change the activesheet.

If you want to gray out a button, this would be very difficult. I think the
best you could do and check the sheet count for
ActiveWindow.SelectedSheets.count and then have your macro react accordingly.

--
Regards,
Tom Ogilvy


"Michael Mueller" wrote:

Hi.

If the user selects muliple sheets using Ctrl+Klick, no event is being
raised - or I missed it.
But if the user does so I would like to disable some of my own
command-buttons.
Is there any change on reacting on grouping sheets?
Excel itself does this - look at the icon for creating charts - but does not
provide any event here :-/

Michi