Macro links to other workbooks

[Jim G]

I've exported several macros to be imported into other workbooks when they
are first used.

When a macro is imported it retains the link to the original workbook. How
do I remove the links?

It's likely I'm missing somehting obvious but I'm lost for looking.

 

[Paul Morgan]

Not sure without seeing the code, but possibly
thisworkbook.something is the key example
ThisWorkbook.Save
ThisWorkbook.Close
thisworkbook.sheets("Sheet1")

 

[Jim G]

Correction: they aren't linked to the original workbook. It's the name of
thisworkbook. When I write a macro that creates the buttons, I can't put
thisworkbook.name in the "OnAction" command.

 

[Dave Peterson]

This kind of thing works for me:

..OnAction = "'" & ThisWorkbook.Name & "'!" & "somemacronamehere"

 

[Jim G]

Thanks Dave, worked perfectly. The double quotes and apostrophe's get me
every time!