Group Mode

[Larry.LeBlanc@O]

Does anyone know of a way for VBA to warn the Excel user if s/he enters group mode (more than one sheet selected, so data entry writes to all selected sheets)?

Thank you!

[shg]

In ThisWorkbook:

Please Login or Register  to view this content.

[6StringJazzer]

shg's code will notify the user after they have made a change. This version will notify the user if they change the cell selection but haven't made a change yet:

Please Login or Register  to view this content.

However, I can't find anything that will notify the user if they simply enter group mode and haven't done anything else.

[Larry.LeBlanc@O]

Thank you.