Ive just thought of another issue! (sorry)

I want to share this spreadsheet with other peopel on a shared drive location.

When they open the form they will save it to their own PC's, complete the form and then email back to me. In effect my form is the template they need to complete a timesheet.

In this scenario how do I ensure the form is saved with all fields blank in the shared location (for users to open and access), but after they have opened it up the Code I have just written initiates so that they must complete certain fields before saving? (they would then email me the completed form)

In effect at the moment for me to save this spreadsheet to a certain location will mean I need to populate fields beforehand?

Am i making sense and is it possible to save the spreadsheet with blank fields and only when they start filling it out themselves does the code initiate?