Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Register user on worbook open
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
London Excel User Conference - Register now, it is not too late | Excel Discussion (Misc queries) | |||
London Excel User Conference - Register now, it is not too late | Excel Worksheet Functions | |||
London Excel User Conference - Register now, it is not too late | Excel Programming | |||
Open Worbook and Disable Macros | Excel Discussion (Misc queries) | |||
Open Worbook and Disable Macros | Excel Programming |