Hello,

I have a huge spreadsheet, but what I want to do is to send one worksheet from it to an indvidual. So when the suer clicks send, it will automatically abstract the worksheet and the user will only receive this and nothing else.

How is this done

Thanks

Alan

Hi Alan

Make a VBA-code that copies ActiveSheet to new workbook and after that you send the new workbook.

Sub CopySheet()

    ActiveSheet.Copy
    ActiveWorkbook.SendMail "[email protected]", "Subject"

End Sub

-vemaju

Thats great, but I have a slight problem! That copies the worksheet that i want to send, but it creates a new workbook, which i don't want to happen. All I want is for the relevant worksheet to be extracted and for that to be emailed to the user is that possible.

Close the workbook without saving it.
Sub CopySheet()

    ActiveSheet.Copy
    ActiveWorkbook.SendMail "[email protected]", "Subject"
    ActiveWorkbook.Close SaveChanges:=False
End Sub

-vemaju