assigning a macro

[Woodyexcel]

Help????
I am using one macro that is assigned to a button on the tool bar. I want to use it with mutiple files that have different names and the name changes. How would I make this work? thanks in advance.


Woody

 

[wigi]

What is code behind the button?

You could use ActiveWorkbook, ActiveSheet, Selection, ... to "generalize" a macro, rather than operating on the same hardcoded sheets and workbooks.

 

[Woodyexcel]

ThisWorkbook.Multisort
It automatically assigns the name of the workbook I am working in. Is the problem that the macro is in the workbook? How do I make that a general macro?

Woody

 

[wigi]

Just like I said, use ActiveWorkbook, for instance.

 

[Woodyexcel]

I made a module in the personal.xls and saved it. Then I assigned it to the button, it will now sort the workbook not matter the name. Is that easier than your idea Wigi?

Woody

 

[wigi]

I made a module in the personal.xls and saved it. Then I assigned it to the button, it will now sort the workbook not matter the name. Is that easier than your idea Wigi?

Woody

Do you still use ThisWorkbook in your code for the button in Personal.xls?