Register user on worbook open
 

Hi!
I have a WorkBook that many users work with.

If there is any critical changes, or data is deletet, the WB register
and logging the username and date on one of the sheets.

The WB logg macro get the username with the: "Application.UserName".

My problem is that the users dont register their peronal names in excel,
so the logg only contains the standard username for that company.

What I am trying to make, is an dialogbox that appear if the WB is open
by the standard name ("BPPassPort User"), where the user can register
his name in a textbox.

Is there any possibility to paste the name the user write in the
textbox, in to the excel user register?

There can of course be smarter ways of doing this, but this was the one
I am able to figure out.

I am grateful for all help!

Axel


*** Sent via Developersdex http://www.developersdex.com ***

Register user on worbook open
 

Hi,

Try

ThisUser=Environ("Username")


Mike


"Axel" wrote:



Hi!
I have a WorkBook that many users work with.

If there is any critical changes, or data is deletet, the WB register
and logging the username and date on one of the sheets.

The WB logg macro get the username with the: "Application.UserName".

My problem is that the users dont register their peronal names in excel,
so the logg only contains the standard username for that company.

What I am trying to make, is an dialogbox that appear if the WB is open
by the standard name ("BPPassPort User"), where the user can register
his name in a textbox.

Is there any possibility to paste the name the user write in the
textbox, in to the excel user register?

There can of course be smarter ways of doing this, but this was the one
I am able to figure out.

I am grateful for all help!

Axel


*** Sent via Developersdex http://www.developersdex.com ***

Register user on worbook open
 

Thanks!
I try that out


*** Sent via Developersdex http://www.developersdex.com ***