Without seeing the code, it is hard to diagnose a problem. However,
you need not merge the two procedures into a single procedure. Just
create a new proc that calls each of your existing procs:

Sub NewProc()
NameOfSaveProcedure
NameOfEMailProcedure
End Sub

Here, NameofSaveProcedure is called and NameOfEmailProcedure will be
callled when the save procedure ends and returns control to the
NewProc. If your two existing procedures work fine independently,
then they will work when called consecutively by another procedure.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Wed, 10 Feb 2010 11:38:06 -0800, Dgwood90
wrote:

I am wanting to run 2 commands when I click a particular button. One command
saves the spreadsheet, the other sends spreadsheet via email. They both work
individually, but when I try to combine, I receive errors.