Attach menubars to a file

[BlueMonkey]

Hi,

This is probably a really simple answer for someone out there, but I haven't been able to find the answer within Help.

Can I attach a custom menubar to a specific file - ie it opens only with that particular file.

Cheers

B.M. Blue Monkey

 

[combo]

If you have access to old excel 95 - you can do it quite easy, menu will stay in the file when you upgrade file. Menus in newer excel versions can be created using VBA (created while opening file and deleted while closing).

combo

 

[BlueMonkey]

Thanks combo. I don't have access to XL 95, so I guess it will have to be VBA.

Can you give me a starter for ten, and list the VBA command to add a new menu and menu bar - I'm going in circles with no real success. Interestingly, I've recorded me creating a new menu, but playing this macro back doesn't name the menu as I did!

Thx in advance. Blue Monkey

 

[combo]

There were some threads in VBA section, one with my answer: thread68-466996
Search this forum and you will find a lot of stuff.

combo