Display only active sheet when saving and sending
Hello,
I am new to the forum and have a question, I would like to only display the active sheet when I save and send. The code I currently have sends the entire workbook. Where would I put this string? My current code is listed below.
Any assistance is greatly appreciated.
Please Login or Register to view this content.
Last edited by sacastiglia; 07-19-2014 at 11:04 AM.
This code creates a new copy of sheet1 in a new workbook.
Send this copy
And then discard it.
Please Login or Register to view this content.
Hi, and welcome to the forum. Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Fixed. Thank you.
It did not work when added to the current code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks