2 macros in one button?

[hond]

Hello,

Is it possible to assign 2 macros to 1 button? The macros I want to combine are:

Sub Invoicelog_Button2_Click()

Dim fname
fname = "My path " & Format(Now, "dd mmm yy") & ".xls"
ActiveWorkbook.SaveCopyAs Filename:=fname

End Sub

And:

Sub Invoicelog_Button2_Click()

Range("K3").Value = Now()

End Sub

Now, it gives me an error: Ambigious name detected

I am new to VBA, can anyone help me?

Thanks

[liamsnodden]

Im not great with VBA but would you not be able to create a new macro to call the two processes you want to run, and then assign that macro to the button?

Sub Button_Click()

Call Macro1

Call Macro 2

End Sub



I might be way off of the mark, but give it a try?

[Trebor76]

Hi hond,

Welcome to the forum!!

Please make sure you wrap all code with the appropriate tags as I have done.

You could have two macros from the same button if your macro actually changed the button name so it could distinguish which piece of code to run. The problem above is that you cannot have the same macro name twice in the same workbook.

You could simply combine the two statements into one macro like so:

Please Login or Register  to view this content.

HTH

Robert

[rollis13]

Why not just merge the two macros.


PS. that's what Trebor76 just said

[Fotis1991]

See here.

http://www.excelforum.com/excel-prog...-1-button.html

[hond]

Thank you all!

How do I mark this as solved?

P.s. just learned VBA today so I didn't know how to merge macros.

[Fotis1991]

You are welcome.

See at Trebor's or my signature to see how you can mark this as SOLVED.