Run macro from addin - xlsx workbook

[Formula11]

Is it possible to run a macro from a normal xlsx workbook, with the macro located in an addin.
I've tried using a text box, right-click Assign Macro, this didn't work.

 

[JoeMo]

Yes, you can run a macro from an xlsx workbook when all the macro code is located in a xla, xlam, or xlsb workbook. To save an xlsx workbook containing any VBA code you will have to accept that all code will be removed in the save.

 

[Formula11]

Thanks for replying.
Yes you're right, it was because I had to input path with the right-click, Assign Marco:

'....folder_path\add_in_name.xlam'!Sub_Name

 

[Formula11]

Would it be possible to run a macro by clicking on a hyperlink?
Again the macro is in the addin and the workbook is xlsx.

 

[JoeMo]

Would it be possible to run a macro by clicking on a hyperlink?
Again the macro is in the addin and the workbook is xlsx.

Never done that myself with the macro in an addin installed in the xlsx workbook so I'm not sure.

An alternative would be:

Put the macro in a .xlsm or.xlsb workbook (let's call it WkBkX)​

In a Thisworkbook Workbook_Open module for WkBkX, Call the macro you want to run​

In the xlsx workbook add a hyperlink that, when clicked, opens the WkBkX workbook​

​

 

[Formula11]

OK thanks I'll try that.

 

[JoeMo]

OK thanks I'll try that.

You are welcome - thanks for the reply.