Good morning,
if there a way that I can have an alert pop up if multiple sheets are active(selected by Ctrl+Click)
Thanks
Good morning,
if there a way that I can have an alert pop up if multiple sheets are active(selected by Ctrl+Click)
Thanks
This will trigger whenever selected cell changes and sheets are grouped.
You may want a different trigeer - modify to suit
In general module:
In all sheet modules:Please Login or Register to view this content.
Test in attached workbookPlease Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
This i a tough one....
The following code will give the alert that there is more that one sheet selected
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.Please Login or Register to view this content.
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!
Perfect thanks guys, this is exactly what I was trying attempt.
Does that solve your problem? -
see Thread Tools at top of thread to mark thread SOLVED
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks