98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Macros
Macros
Resolved · Low Priority · Version 2003
Mon 8 Sep 2008, 16:37Delegate Melanie said...
Melanie has attended:
Excel VBA Intro Intermediate course
Macros
I use a macro that gives the user the option to email the workbook to me. Can you show me how to amend this so that only one worksheet is emailed rather than the whole workbook. Thanks
Thu 11 Sep 2008, 10:40
Edited on Thu 11 Sep 2008, 10:44Trainer Carlos said...
Macro to Email a Single Worsheet
Dear Melanie
The best way to send just one sheet from a workbook is to create a new Workbook with just that sheet in it and then sending the new Workbook as an attachment.
In the example you create a new workbook from the
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display developer tab - Excel 2010a. In Excel, click on the File tab |
