W2K Username Available in Excel??

[binky]

I am trying to figure out how to get the logged in username within the start up of an Excel spreadsheet.

Any ideas??

I have looked at and used the code posted for Access to do this but it doesn't work in Excel.

Thanks in Advance

Ken :

 

[binky]

I have figured out how to get the info I need. What I now need help with is how to prevent the sercurity warning from popping up (enable/disable macros) and how to disable the shift key.

Any thoughts!!

TIA
Ken :

 

[ETID]

Goto Tools>Macro>Security...select low in the security levels tab

 

[ETID]

Oh yeah ...and this FAQ might help with the user ID thing

faq68-1077