When sheet is activated, execute macro in other sheet and return to sheet

Hey all,

I got problems, and hopefully someone in here can help me out

The thing is that I, when activating worksheet "SetUp", I want to execute a code (showsheets) in the worksheet "Ark1".
The code i want executed is:

Please Login or Register  to view this content.

and the code I use is:

Please Login or Register  to view this content.

At the moment, the macro is executed in the worksheet "SetUp" (the wrong sheet). I tried to activate "Ark1", execute code and return to "SetUp", but it didn't work. Please enlighten me Thanks!

Thanks for the quick assistance! Last thing: How do I avoid hidden sheets being listed? I tried to insert following line, but didn't work:

Please Login or Register  to view this content.

But almost there Thanks for the help so far!

btw: your suggestion was absolutely right: I wish to get the output in the Set sheet.