Creating Menus

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Oct 31, 2005

• #2

I don't really know about .xla files, but the code the HTML Maker uses to create the menu is from John Walkenbach, and is available here:

http://www.j-walk.com/ss/excel/tips/tip53.htm

I have used this before on one of my own projects; seemed to work rather well for me

 

Upvote 0

S

Ste_Moore01

Active Member

Joined

Jul 13, 2005

Messages

467

• Oct 31, 2005

• #3

Thanks for that link.

It helps but unfortunately the file you download has to be open all the time.

Is there a way of adding menus without having to open a certain file all the time?

 

Upvote 0

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Oct 31, 2005

• #4

The file you download from that page is simply an example.

All you need to do is create a sheet and copy the macros to *your* workbook to use it

 

Upvote 0

tusharm

MrExcel MVP

Joined

May 28, 2002

Messages

11,029

• Oct 31, 2005

• #5

A menu has to be connected to some code. If it is not, it won't do anything!

That code has to be in some workbook that has to be open (or better yet in an add-in that has to be loaded). So, the addin can contain the code to create the menu as well as the code associated with the menu.

Ste_Moore01 said:

Thanks for that link.

It helps but unfortunately the file you download has to be open all the time.

Is there a way of adding menus without having to open a certain file all the time?

Click to expand...

 

Upvote 0

S

Ste_Moore01

Active Member

Joined

Jul 13, 2005

Messages

467

• Nov 1, 2005

• #6

Thanks for the help guys and gals!

I was hoping to be able to make an add-in but was unsure how to do it.

Has anyone got any links to a tutorial on how to make one, or could someone try and explain please?

I'm just trying to put all my essential things on a menu like the file menu, rather than having to waste time looking for them.

Thanks!

 

Upvote 0

S

Ste_Moore01

Active Member

Joined

Jul 13, 2005

Messages

467

• Nov 1, 2005

• #7

I've managed to make a menu that comes on when opening up by saving the menu amker file in XLStart in the Office folder in Program Files.

If you save it there and hide the workbook it's as though there is just another menu.

There is an annoying message which pops up every time but I can live with that.

I'm still curious as to how I can make a "real" menu instead of the one I have.

 

Upvote 0