Emailing Help

G

Guest

Hello,

I was wondering if anyone could help me. I am trying to get a code to copy
a worksheet (command button on one sheet [named home], the sheet I'm trying
to copy is hidden[named hidden]), paste special to a new worksheet with
formats and values, then emailing the new worksheet to a distribution list in
another cell (if this part is possible, if not I can enter the addresses by
hand), close/delete the new worksheet with out saving it, and return to the
'home' worksheet.

Thanks

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Emailing a worksheet 1
Copy Template with Updated Values Each Time 0
hyperlinking to charts in file 1
how to copy worksheet to new workbook with values only 3
file path or IP address protected 1
Copy hidden worksheet 4
Protect each worksheet individually 4
Code to copy worksheet 5

Top