Remove the filename when assign a macro to a menu command.

[Guest]

When i assign a macro to the menu command's button. it always shows the macro
name with the filename of workbook. ex: C:\My Project\MyFile0712.xls!macro1

How do I remove the filename name or the path name?

 

[Tom Ogilvy]

You don't. The button has to be linked to a specific instance of the macro.

If you mean how do you change it to point to another workbook, you would use
the onaction property of the button.

 

[Guest]

Hi, Tom. Thanks for your help.

What i need is assign the macro always to thisworkbook (the workbook contain
the macro), no matter what filename it changed to. Does it possible?

 

[Tom Ogilvy]

Reassign it in the Workbook_Open event using the OnAction property.

No built in support for what you describe. You have to do it with code.

 

[Guest]

so... if i don't write any code in the Workbook_Open event. i must put the
workbook file on the same path folder with mine?

Oooop! i create a workbook and want to distribute to 10 users, i must create
the same folder on every machine.... :~~