Display a message when worksheet is active

**julvaz** · 03-05-2007, 03:48 PM

Hello all,

What code can I use in order to display a msgbox when a worksheet is active??

Thank you all

**Simon Lloyd** · 03-05-2007, 04:00 PM

This goes in the ThisWorkBook module:

Please Login or Register  to view this content.

every time you change sheet you get a message pop up to tell you which sheet has been activated!

Regards,
Simon

**julvaz** · 03-05-2007, 05:19 PM

Originally Posted by Simon Lloyd

This goes in the ThisWorkBook module:

Please Login or Register  to view this content.

every time you change sheet you get a message pop up to tell you which sheet has been activated!

Regards,
Simon

Thank you Simon ( :

**Simon Lloyd** · 03-05-2007, 05:20 PM

Glad to help!

Regards
Simon