Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using code from custom menu bar to a Command button
Hi, I am using Excel 2002 and I want to imporove upon a co-workers workbook. The particutlar workbook that I am working is called "Reviewers", which has a custom menu bar call "Cust Menu" when you press the menu bar button it activates a copy and paste command based on a seperate macro file called "Transfer". The "Transfer" file opens up when the "Cust Menu" button is pressed, not a problem it works fine, but now I want to have a separate command button on the worksheet that will do the same copy and paste command as in the "Cust Menu" I know how to create a command button I don't want to create a separte macro, in case I need to change the orginal macro in the "Cust Menu" bar. What I want is to have the command button to open up the "Transfer" macro file and get access to the code in the "Cust Menu" button.. How do I do this? Any tips will be appreciated. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Placing a Command Button in a New Tool Menu | Excel Discussion (Misc queries) | |||
Custom Command Menu Bar Part 2 | Excel Programming | |||
Command/option/spin button - no control menu available | Excel Programming | |||
Macro as Custom Menu Command | Excel Programming | |||
Close button on Custom Menu Bars | Excel Programming |