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" wrote:

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.

--
Regards,
Tom Ogilvy

"OKLover" wrote in message
...
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?