Excel macro to send excel worksheet

Steve,
Some time ago, I was trying to do the same thing, and looked for help here. Eventually I had to give up. My solution was to copy the worksheet to new workbook, then send that workbook. My workbook was very large and each sheet had a lot of formulae, so this ended up being slow. What I finally did was copy the contents of the worksheet into a new workbook and send that. All sorts of issues with formulae etc, but it does the job.
My macro does this for about 120 sheets, one after the other. I'm using Office 2000. My problem now is that Office now comes up with a warning for each sheet that a program is trying to automatically send an email, is this OK, and waits 5 secs before I can click Yes. What, under an older version of Office, ran automatically, now I have to click Yes 120 times, and wait 5 secs between each one. Question for you, do you know how to overcome this?

Richard

Yes i agree Microsoft have not really solved this, i too have tryied [NT]