Welcome message of username in cell

Hi I would like to place a welcome message in cell B5 when the user opens the workbook. I managed to find a code and have placed this on the attached file. Can i have some guidance on how do i link the code to cell B5.

Try

Please Login or Register  to view this content.

but your code needs to go in the ThisWorkbook module, not the sheet module

Hi Bakerman2. Thank you for the response. Should i paste it in the worksheet or insert into a new module. By the way can i know whats the difference between both.

Thank you both. It works nicely. Appreciate the advice.

Glad we could help & thanks for the feedback

Hi Sry I may have missed out this sub question. If i would like the code to appear on Sheet2 and Sheet3 on the same cell B5, How could i amend this code?

Thanks You!!

Simplify the code and place it in the Thisworkbook module

Username welcome.xlsb

@bakerman2, You are right on my fault. I am therefore only a Registered User

Nb. Waar ken je me van of onder welke nickname wandel(de) je rond op Nederlandse fora? Al heb ik een vermoeden maar dan klopt jouw avatar niet

@bakerman2, dan was mijn vermoeden juist Rudi(e) als ik het goed heb. Volgens mij allang niet meer gezien op helpmij.nl.

Hi, I just saw this reply. Can i check whats the difference between the xlsb and the xlsm file? I do have other tabs with graphs and forumla on the cells so i am wondering if there will be any issues.