Assign Macro To Button At Runtime

[Guest]

Hi ,

I am creating a button thru macro and assign a function named Refresh.
It is executing well. While opening the workbook, there is an error pops up
"Macro name is not valid, check the name"

But macro is executing . IS there any way to find out what is the problem

My macro is in Module1 .

Sub refresh

end sub
OR
function refresh
End function
which is correct

but for both having issue

 

[Harald Staff]

Hi

You don't share the creation/assignment code, but try assigning to

ThisWorkbook.Name & "!Refresh"

and see if it helps.

HTH. best wishes Harald

 

[Rob van Gelder]

If you have a button created by the Forms toolbox, then you can assign the
macro at runtime as this example demonstrates:

Sub test()
ActiveSheet.Shapes("Button 1").OnAction = ThisWorkbook.Name & "!Refresh"
End Sub

Public Function Refresh()
MsgBox "Hello World"
End Function