Multple active sheets alert

[HPIMICHAEL02]

Good morning,

if there a way that I can have an alert pop up if multiple sheets are active(selected by Ctrl+Click)

Thanks

[kev_]

This will trigger whenever selected cell changes and sheets are grouped.
You may want a different trigeer - modify to suit

In general module:

Please Login or Register  to view this content.

In all sheet modules:

Please Login or Register  to view this content.

Test in attached workbook

[Maudibe]

This i a tough one....

The following code will give the alert that there is more that one sheet selected

Please Login or Register  to view this content.

But I am guessing you want the alert to popup automatically when a multiple sheet is selected and not by manually running a code to check for it. There is a Sheet_Activate event in the work book module that detects a new worksheet has been selected, however, when selecting the additional worksheets, they are not detected because they are selected behind the first selected worksheet which remains the active worksheet.

The same is true of the worksheet_Activate in the sheet's module. It doesn't fire if selected in addition to another worksheet because the first worksheet remains active. I wrote a quick class module but it does not detect the additional worksheet either

An alternative approach is to monitor for for the text [Group] in the workbook's caption but again, there is no event for it. Unless someone else has a technique I am not aware of, looks like this can be checked only by running the code manually or by piggybacking off another event like when the user selects a cell on any sheet (other that a chart sheet).

HTH,
Mud

OOPS: I was too late!

[HPIMICHAEL02]

Perfect thanks guys, this is exactly what I was trying attempt.

[kev_]

Does that solve your problem? -
see Thread Tools at top of thread to mark thread SOLVED
thanks