Custom Menu Bar

Topic

New Reply

I borrowed a coworker’s Personal.xls & Excel11.xlb files. ( I created them for her and now my computer crashed)

The personal.xls works fine. All of the macros are there and function OK.

I created a custom menu using the Customize/New and named it ReportsMenu

My question is – how do I associate the Custom Menu Bar with the Excel11.xlb file?
(Located at C:Documents and SettingsAbramsMApplication DataMicrosoftExcel (outside of the XLStart folder)

Thank you very much for your help.

Michael

Reply | Quote

Replies

You could try opening the .xlb file and see if that works. If not, you’ll probably have to reassign the macros to the toolbar buttons one by one.

Reply | Quote

You could try opening the .xlb file and see if that works. If not, you’ll probably have to reassign the macros to the toolbar buttons one by one.

Looks like it’s going to be 1 by 1. So sad……….

Thanks Hans !

Michael

Reply | Quote

Excel stores the absolute path to the macros; it’s different for you than for your coworker (since the path contains the username)…

Reply | Quote

I created the custom toolbar (Reports)

When I drag a custom button from Commands/Macros to the new toolbar, the title Reports goes away, and the macro IS the toolbar. There is no ‘dropdown’. I hope I am describing this clearly).

I cannot imagine what I am doing wrong. Can you assist?

Reply | Quote

Make sure that you drop the macro squarely on the toolbar and not beside it (the latter is easy to do if you want to add the button at the end, it has happened to me several times)

Reply | Quote

Make sure that you drop the macro squarely on the toolbar and not beside it (the latter is easy to do if you want to add the button at the end, it has happened to me several times)

This is so frustrating.

When the toolbar is created, it appears ‘on’ the spreadsheet. I placed the button squarely on the toolbar.
The title Reports still apears, and the button is ‘in’ the toolbar.
When I drag the new toolbar up to the Standard toolbar, the button replaces the word Reports.

I will keep trying though !!

Thank you Hans.

Reply | Quote

If a toolbar is docked at the top of the Excel window, like the Standard and Formatting toolbars are by default, its title (caption) isn’t displayed, only the buttons. When you undock it (use the “handle” on the left hand side to drag it away from the top), the title bar will appear again. This is “normal” behavior for toolbars.

Reply | Quote

If a toolbar is docked at the top of the Excel window, like the Standard and Formatting toolbars are by default, its title (caption) isn’t displayed, only the buttons. When you undock it (use the “handle” on the left hand side to drag it away from the top), the title bar will appear again. This is “normal” behavior for toolbars.

Wow !

On my previous computer it sat right on the top menu bar and said Reports with a dropdown of the macros.

It works fine now that I know this.

Thank you Hans !

Michael

Reply | Quote

On my previous computer it sat right on the top menu bar and said Reports with a dropdown of the macros.

That makes me think that you created a custom menu named Reports, with the macros as menu items.

To create a new menu, select New Menu in the list of categories in the Commands tab of the Customize window, then drag New Menu from the list of commands on the right to the menu bar (or to a toolbar). Right-click the new menu to change its name. You can then drag commands or macros to the new menu.

Reply | Quote

I think you will benefit from reading my primer on custom toolbars and menus here:
http://www.jkp-ads.com/articles/distributemacro03.asp

In fact, seeing you are messing with other’s personal.xls, I would start here:
http://www.jkp-ads.com/articles/distributemacro00.asp

Reply | Quote

First of all, I would like to thank Hans for your patience and pieterse for the tutorial.

You guys are awesome and I really appreciate the time you take to share your knowledge (and patience)

Very Sincerely,
Michael Abrams

Reply | Quote

You are very welcome!

Reply | Quote