Ali wrote:
However I want the first macro to return the button with the name
"update" - at present it returns a macro called button 2, button 3 etc
which then crashes the second macro.


Assuming that this is a Forms toolbar button then

With ActiveSheet.Buttons.Add(1, 2, 3, 4)
.Name = "Update"
.OnAction = "MyMacro"
End With

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup