VBA Help Command button

[Mortenkamstrup]

Hello every one

I have a code where i transform some data to a new sheet which i create by a macro. in each new sheet i create a new button will be created with this code:

Dim btn As Button
Dim t As Range

Set t = ActiveSheet.Range(Cells(2, 15), Cells(2, 15))
Set btn = ActiveSheet.Buttons.Add(t.Left, t.Top, t.Width, t.Height)


The idea with the button which i create on each sheet is to assign another macro which i should use later for each sheet, but i dont know how.
something like:
Assign macro to Btn = ModVersion2

and then the macro in modVersion2 should be assign to the button so i later can click the button for use the macro?

Any kind person who can help me? I can share my Excel ark if it would help just need a litle help to how i should do it

Thanks alot in advance.

 

[HotRhodium]

Sure ...


Could you Try This

btn.OnAction = "MyMacro1"

and see if it works I have no idea worth a shot yes?

 

[Mortenkamstrup]

it was worth a shot

Unfortunatly i get a message which say: The macro may not be able in which workbook or macro may not be enabled.

If i run the macro by pressing Alt F11 and run it works

But thanks for the try and now i get a message then i click the button, do not know if i use the right module form or where the problem are

once again thanks for your try and effort