Menu for Macros

[Cap2010]

hi,

I have created lots of Code and want Menu
to display all the buttons whenever Excel is opened.

How to do it.

Cap

 

[PHV]

Have you created a custom toolbar ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Cap2010]

No, not created custom toolbar.

Then tried creating custom toolbar and transferred New Menu
and in that dragged custom menu item.

On restarting Excel neither menu appears i.e. New Menu nor custom menu item.

Cap2010

 

[PHV]

Save your new menu and the code in the Personal.xls workbook.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Cap2010]

hi,

Thanks, I have saved it in Personal.xls with a code in VBA

Private Sub Workbook_Open()
Call PersonalMenu
End Sub

Captain