I am looking to write a macro that takes worksheets from a workbook, protect them, save them to idividual workbooks and then email each individual workbooks to nn addresses. All of this off of minimum key strokes.

The macro to protect, copy, and resave worksheets as a new workbook is fine, but I am struggling to email the individual worksheets off of the same macro function. Any ideas would be welcomed.

With grateful thanks

TC