Hello,

I found a macro code that hides all worksheets except the one the user knows the password for.

But my company doesn't want to send en mass a workbook with hidden sheets because it is well known that Excel passwords can be easily recovered.

Does anyone know of a macro that will email each separate sheet to a specified list of intended recipients? Or do I have to keep emailing each sheet one by one?

I pray there is!