Run time error 1004 on userform initialize

I was in the middle ** working on my workbook and for some reason I'm now getting Error 1004 on my user Login user forms that load when the workbook opens. I can't figure out why, so I went back to my latest backup from this morning and exported the user forms from that workbook (which work fine) and imported them into my current workbook, and also copied over all the code in ThisWorkbook, but it still gives me the same error (even though they work fine in the backup workbook). I have done so much since the backup tho morning, that I dont know what I have done to mess it up.
The userforms are called Users and Users2.
I also noticed that the Change_Event code for the sheets ReturnData and EquipmentData stopped working. In the case ** ReturnData its supposed to add todays date into the G column when data is entered into G. I dont know if this is linked to the issue.
Thank you for you time,
James

Try with other userforms names

This is actually where the error is.

Please Login or Register  to view this content.

I think you need to check out your named range 'Usernames'.

PS Why does that range start at A3?

The formula used for the named range 'Usernames' evaluates to #REF!.