Vba username code issue

[rebel_yell]

Hi

Ive got an issue with a get username function:

Please Login or Register  to view this content.

Now the above command will be used in a shared workbook and works for my user, but as soon as another user loads the workbook, the username stays the same and only works if the formula is deleted and re-typed.

Is there a way around this as I need the process to be fully automated.

Thanks in advance

A very confused Adam J

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.