Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping sheets copies Header across to all sheets | Excel Worksheet Functions | |||
Grouping Sheets | Excel Discussion (Misc queries) | |||
Grouping in protected sheets | Excel Discussion (Misc queries) | |||
grouping sheets | Excel Programming | |||
Grouping Sheets in VBA | Excel Programming |