Vba problem

Hi Guys,

I have a test spreadsheet that finds your user name and the date and time when you first open it and then if you were to save it and then open it again it wont change as the fields are already full. this is beacuse the form is only changed once and then saved somewhere else and so the template never changes.

the problem is I can only get it to work on my computer and if i copy and save it into other peoples drives it doesnt work when they open it.

any thoughts on how to fix it?

Thanks!!

Is it possible that their trust center is not set up to enable the macros on this workbook? They might have that annoying pop up bar at the top that needs to be enabled before the VB auto_open will run.