Hi,
today I have wondering is it possible (and how 
) that button appearing is coded in another macro.
Let's say: I'm starting a macro (macro1) in a sheet (sheetA). This macro, beside doing other jobs, creates also a button in other sheet (sheetB), and the button is linked to another macro (macro2).
Thanks and all have a great week
Kamil
With Worksheets("SheetB").Buttons.Add(50, 3, 60, 20)
.OnAction = "Module1.macro2"
.Caption = "Click Me"
End WithThank you very much JonathanVH! It works smooth
Because I had many buttons to paste I made some changes in "Buttons.Add(50, 3, 60, 20)" and placed them in order.
Best regards,
Kamil
Don’t have an account yet? Register yourself now and be a part of our community!