Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Placing a Command Button in a New Tool Menu Office Junior[_2_] Excel Discussion (Misc queries) 2 May 12th 07 04:50 PM
Custom Command Menu Bar Part 2 rju[_5_] Excel Programming 0 July 7th 04 04:56 PM
Command/option/spin button - no control menu available Daniel[_7_] Excel Programming 3 March 5th 04 03:02 PM
Macro as Custom Menu Command Clint Marshall Excel Programming 6 September 26th 03 07:20 PM
Close button on Custom Menu Bars Aaron[_6_] Excel Programming 2 July 18th 03 03:58 AM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"