Auto insert 'user id' into a cell

[JamesT1]

Good afternoon folk

Each time a workbook is opened is there a way for the sytem to automatically insert the 'user id' for the person logged into the PC

many thanks

JT

[davegugg]

Please Login or Register  to view this content.

This code will do it as long as macros are enabled.

[TMS]

Yes. You'd need to use VBA and a Workbook Open event. You would, of course, have to ensure that the user enables macros.

Regards

[JamesT1]

Thanks guys

davegugg

many thanks works a treat

JT