only display a messagebox when the sheet is activated through user, not macro

hello.

I have this code for every workbook once it becomes the active workbook:

Please Login or Register  to view this content.

Also, when I run macros that add to these sheets, I have the worksheet that it is added to activated.

Is there a way to only display that message box if the user is clicking between sheets but not when the macro is writing to the sheet?


Or to at least have the message pop up after the userform has been closed?

Thanks

thanks joseph,

I will have to try this in a few hours for I have ran out of time in the office. I will let you know if there are any complications!

Hi josephp,

I used that, and it still showed the message.

here is the code I tried it in:

Please Login or Register  to view this content.

and here is the code that is using the event that I want to hide:

Please Login or Register  to view this content.

oh wow! didn't even see that!

It works!! thanks so much!