In MS Excel i want to add a button into a worksheet that Prints the worksheet and allows the user to email me?

How do i create a macro that does this as when i recorded one for print it takes them to the print preview screen and needs them to click print for it to continue. When i recorded an email button macro, i chose send to option and set up an email and sent it and stopped macro. This button does not work currently. any ideas?
In MS Excel i want to add a button into a worksheet that Prints the worksheet and allows the user to email me?
You can create a hyperlink for both commands and add it to the worksheet.


It is a little winded to give you specifics but open your MS Excel.... go to excel help and the little paperclip pops up... type your question as ....





create a customized hyperlink





It will give you the instructions on adding one for the print command and also adding an email button.





Hope this helps you
Reply:if you send me the worksheet to the following email i will have a look at it tonight and send you the answer





i will look at your attempt and point you in the right direction





hope this is ok





northernstar1971@yahoo.co.uk





thanks





david
Reply:To print, link a button to a macro, with this code in the macro





ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True





Edit:


For some reason Yahoo truncates the text of my answer. The bit after "SelectedSheets" says "PrintOut" then a space before the word "Copies"
babynames