Any way to react on grouping sheets?

  • Thread starter Thread starter Michael Mueller
  • Start date Start date
M

Michael Mueller

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
 
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.
 
Back
Top