Menu for Macros

  • Thread starter Thread starter Robert E. Leonard Sr
  • Start date Start date
R

Robert E. Leonard Sr

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
(e-mail address removed)
 
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
 
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
 
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
 
Back
Top