Great hack, thanks :)

It runs fine for everyone except for the very people I decided to install it for...
users awaiting moderation do not see a thing. No box no text. I get the usual "you do not have permission to access this page. This could be due to one of several reasons: blurb" but no message header above. I cant' believe that it is working with anyone including guests and not for the "users who are awaiting approval?", even if it is the only message I ticked :(
What could I do wrong ?

OmniBuzz,

It doesn't sound like there's an issue with the mod but rather with how you want the mod to work. If a user is seeing an access denied page, they won't see the welcome header. What happens if a user awaiting confirmation goes to a page they arent restricted from seeing? What usergroup are using for these members?

Thanks Ted for your quick answer.
The forum I am building right now is a family forum. Meaning it is fully restricted to anyone outside the family. Members of the family we don't know apply for the forum by registering but we don't give them any access until their registration is moderated by a family elder.
The thing is that a few them are not very familiar with the concept of a forum, and once they fill the profile fields we request, do not understand why the system let them access a page where they can see their name (profile.php?do=dst "john smith, you do not have permission to access this page. This could be due to one of several reasons:") and not the forum. A few of them do not even check their mailbox and keep coming back trying to enter the forum with the login/password they just entered.
What I wanted was to be able to display to these users awaiting moderation a specific header message. I mean if vbulletin is able to know that these people are "awaiting moderation" and display their name in a page, Welcome Header should be able to display to them a welcome header ?
Are I am not thinking right ?

You're completely correct with your thoughts -- if you PM me with your URL I can take a quick look and see if I can't tell the problem from the outside.

done, thanks again for your help !

It works now, I have no idea why !!!
Did I have to wait for some sort of cron job before it started to work ?

Weird. No cronjobs here.

Question...

If I was to make some sort of random "tip of the day" type script, and then insert a string to call it with into the header for say the people who are both registred and subscribed (for example), would it work? Or would the string not function correctly by just inserting it in the appropriate place in the admin cp??

Sorry if that's confusing...

If you setup the variable to be accessible globally it would certainly work.