Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove the filename when assign a macro to a menu command.
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove the filename when assign a macro to a menu command.
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove the filename when assign a macro to a menu command.
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove the filename when assign a macro to a menu command.
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. -- Regards, Tom Ogilvy "OKLover" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove the filename when assign a macro to a menu command.
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.... :~~ "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "OKLover" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro does not assign to menu? | Excel Discussion (Misc queries) | |||
I can't find the Assign Macro command | Excel Discussion (Misc queries) | |||
Assign a macro to a command button | Excel Discussion (Misc queries) | |||
Assign macro name to menu command w/o using workbook name | Excel Discussion (Misc queries) | |||
canot remove command from FILE MENU | Excel Discussion (Misc queries) |