VB Code to show hidden Excel worksheet

Hello all,

I have found code that allows me to save a workbook with a new name and then email it the saved file.

The problem that I'm having is the ORIGINAL Excel file only shows one page (the input page) - that's perfect for the 1st part of the required use; however, I need the emailed workbook to have additional sheet shown when the recipient opens the file.

Any help that can be given on how to do this – would be greatly appreciated. Below is the Code that I’ve used:

Please Login or Register  to view this content.

Thank you both for addressing my question, I appreciate your help.

Xladept - I added the code as you stated; however it did not work.

Arkadi - I will not be editing it - the master is going to be used by many and then the emailed file is going to be sent to another perso; so, I'm not sure if your idea will work for this situation.