ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using code from custom menu bar to a Command button (https://www.excelbanter.com/excel-programming/341192-using-code-custom-menu-bar-command-button.html)

Alex Martinez

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.





All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com