Hi Folks

Very new to all this and I'm currently designing an excel based form to replace a paper based one we use.

Once the user has completed the data entry I'd like them to be able to hit one button in the worksheet which will then do the following:

Name the file based on information held in a cell, say A1
Save it to a location
Password protect it
Attach to an email

Hoping someone can help with this as the aim is to make life as simple for the user as possible - experience tells me the more things I ask them to do the more things they will get wrong!

Many thanks in advance

James