I currently have the following code that is customized to take parts of a sheet and paste it in a new sheet and then attach that sheet to outlook. The problem with this is that the user cannot see the sheet until they open the attachment from outlook. so basically if there are changes to be made the user will have to open the sheet, edit and resave and reattach. what I am trying to do it to insert another button onto the main sheet that will allow the user to open the sheet and not attach it to outlook. Also, I would like to have the file name "YTD Production" Any ideas on how I could edit the following code to do this. The code below is mainly bits and pieces of the actual code but hopefully the current concept makes sense. if not i can clarify, Thanks so much for your help with this.


Please Login or Register  to view this content.