Hi every1.
I hope some1 in here can help me.
I have a macro which creat a new sheet with a botton which have a macro.
Below you see the macro i have, and it is working perfect.
Set t = ActiveSheet.Range(Cells(2, 15), Cells(2, 15))
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
btn.OnAction = "Modversion2.OpdateBlokVersion2"
Now i just want the bottons name to be ("Update data") instead of botton 1.
I believe i only need 1 line of text (Might be wrong here)
Can any1 help me with naming my botton?
Thanks alot in advance.
I hope some1 in here can help me.
I have a macro which creat a new sheet with a botton which have a macro.
Below you see the macro i have, and it is working perfect.
Set t = ActiveSheet.Range(Cells(2, 15), Cells(2, 15))
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)
btn.OnAction = "Modversion2.OpdateBlokVersion2"
Now i just want the bottons name to be ("Update data") instead of botton 1.
I believe i only need 1 line of text (Might be wrong here)
Can any1 help me with naming my botton?
Thanks alot in advance.