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

Question

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?

Answer 1

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

Answer 2

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"

Answer 3

hi the printing is amazingly elementary. a million. Insert a image asserting Print. (it particularly is much less complicated to apply a image) 2. suited-click on image and sau "Assign Macro" 3. in case you prefer it to pop the Print field, the place you are able to decide on yet another printer and the quantity of copies, sort : application.Dialogs(xlDialogPrint).Sho... (hover you mouse over the command above to work out the entire component, for some reason i'm getting ... the entire time) 4. in case you allready have been given a Print rage chosen, and you already know the printer is default, and you in simple terms prefer it to print you prefer to apply between right here : activeworksheet.printout activeworkbook.printout 5. it particularly is it for printing... To mail you is amazingly elementary, in simple terms sort in the single cellular digital mail : and then to the cellular next to it, sort your digital mail adress. If the guy click on you mail adress, his outlook/outlook show will open via it self. wish this helped a sprint, positioned extra records, in case you ment something else with the mail...

Answer 4

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

[e-mail]

thanks

david