 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Menu for Macros
I have a worksheet on which i have developed several macros that are associated with their own button. I am trying to develop a menu within the worksheet to place the buttons. Like a pop up menu, so that where ever I am in worksheet I can access buttons. I created menu called Macros with the new menu command on the toolbar; but I do not know how to limit it to just the worksheet I am using. Thanks for your help. Bob Leonard rleonard@mich.com You could put all the buttons on a User Form, brought up by a single button on the worksheet. If you know you will only need the macros on that specific workbook, why not create a macro to build the toolbar/menu when that workbook opens, and remove it when the workbook closes? HTH, JP > I have a worksheet on which i have developed several macros that are > associated with their own button. I am trying to develop a [quoted text clipped - 10 lines] > Bob Leonard > rleon...@mich.com You can also "grey out" the buttons when one of your worksheets isn't being used... Robert Read what JP said but substitute "worksheet" for "workbook". I think that is what you want. Post back if you need more. HTH Otto >I have a worksheet on which i have developed several macros that are >associated with their own button. I am trying to develop a [quoted text clipped - 10 lines] > Bob Leonard > rleonard@mich.com Otto, Sounds like what I want. I have a toolbar menu named "Macros SP", How do I create macro to display on only this worksheet and close when worksheet is closed? Bob Leonard Place these 2 macros in your sheet module. To access the sheet module, right click on the sheet tab and select View Code. "X" out of the module to return to your sheet. Note where you put your code to create the menu and remove the menu. HTH Otto Private Sub Worksheet_Activate() 'Your code to create the menu goes here End Sub Private Sub Worksheet_Deactivate() 'Your code to remove the menu goes here End Sub > Otto, > Sounds like what I want. [quoted text clipped - 3 lines] > > Bob Leonard |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.