Toolbar help sought! (Resolved)

Jak · Apr 15th, 2002, 12:08 AM

In Excel I go to customized, new menu and drag the new menu to the toolbar. Once the new menu is in place I go to macro and drag and drop several buttons to make the menu a drop down menu for the macros. Once this is done I assign each button a name and then assign the relevant macro to the button.

This is straight forward enough, but is a little long winded when it has to be done to a large number of PC’s. I have saved my personal.xls and have a .bat file that loads it onto each PC to allow access to the macros and update them as required. What would be better is a method of loading a drop down menu to the Excel toolbar with macro’s assigned. Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function. The method should be built into Excel or a .bat method if possible. Any ideas on how to tackle this problem would be welcomed.

[ This Message was edited by: Jak on 2002-05-15 06:27 ]

Mark O'Brien · Apr 15th, 2002, 10:53 AM

How about creating an Excel Add-in instead?

Jak · Apr 15th, 2002, 12:28 PM

Hi Mark

have you got an example of using the add in function to create a toolbar?

Anne Troy · Apr 15th, 2002, 12:30 PM

I'm curious.

Why no On_Open? When it's a personal.xls file, user's aren't prompted for macros...

Jack in the UK · Apr 15th, 2002, 01:01 PM

Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function

i understand but on-open is dangerouse via Personal xls, many IT dept crunch these as they are used via virus code writters, i only to day passage saying what i though of free anti virus OK most was Excel leant but proove my pont. no i will never explain theis, but suggest against this one. Anyone telling different needs to have virus experience, bar one attack

my youngest son needs me 13 months ill update this more later

klb · Apr 15th, 2002, 01:58 PM

Create your toolbar and save it in a separate workbook.

Then at the user's pc, attach your toolbar to their personal.xls file.

Jak · Apr 20th, 2002, 04:44 AM

Thanks guys for all your insight. I think I will go for the add-ins methodology to solve the problem.

Mudface · Apr 20th, 2002, 04:51 AM

Also take a look at the Menumakr download on Chip Pearson's site, should do most of what you want to do.

Jak · Apr 20th, 2002, 04:57 AM

Hi Mudface

have you got the address for Chip Pearsons site?

Mudface · Apr 20th, 2002, 05:02 AM

Sorry, it's actuallly John Walkenbach's web site:-

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

Chip Pearson's page is very good too:

http://www.cpearson.com/excel.htm

Apr 15th, 2002, 10:53 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	How about creating an Excel Add-in instead? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 15th, 2002, 12:30 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	I'm curious. Why no On_Open? When it's a personal.xls file, user's aren't prompted for macros... __________________ ~Anne Troy

Apr 15th, 2002, 01:01 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function i understand but on-open is dangerouse via Personal xls, many IT dept crunch these as they are used via virus code writters, i only to day passage saying what i though of free anti virus OK most was Excel leant but proove my pont. no i will never explain theis, but suggest against this one. Anyone telling different needs to have virus experience, bar one attack my youngest son needs me 13 months ill update this more later __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 12:08 AM	#1
Jak Board Regular Join Date: Apr 2002 Location: Newcastle upon Tyne Posts: 762	In Excel I go to customized, new menu and drag the new menu to the toolbar. Once the new menu is in place I go to macro and drag and drop several buttons to make the menu a drop down menu for the macros. Once this is done I assign each button a name and then assign the relevant macro to the button. This is straight forward enough, but is a little long winded when it has to be done to a large number of PC’s. I have saved my personal.xls and have a .bat file that loads it onto each PC to allow access to the macros and update them as required. What would be better is a method of loading a drop down menu to the Excel toolbar with macro’s assigned. Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function. The method should be built into Excel or a .bat method if possible. Any ideas on how to tackle this problem would be welcomed. [ This Message was edited by: Jak on 2002-05-15 06:27 ]

Apr 15th, 2002, 12:28 PM	#3
Jak Board Regular Join Date: Apr 2002 Location: Newcastle upon Tyne Posts: 762	Hi Mark have you got an example of using the add in function to create a toolbar?

Apr 15th, 2002, 01:58 PM	#6
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Create your toolbar and save it in a separate workbook. Then at the user's pc, attach your toolbar to their personal.xls file.

Apr 20th, 2002, 04:44 AM	#7
Jak Board Regular Join Date: Apr 2002 Location: Newcastle upon Tyne Posts: 762	Thanks guys for all your insight. I think I will go for the add-ins methodology to solve the problem.

Apr 20th, 2002, 04:51 AM	#8
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Also take a look at the Menumakr download on Chip Pearson's site, should do most of what you want to do.

Apr 20th, 2002, 04:57 AM	#9
Jak Board Regular Join Date: Apr 2002 Location: Newcastle upon Tyne Posts: 762	Hi Mudface have you got the address for Chip Pearsons site?

Apr 20th, 2002, 05:02 AM	#10
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Sorry, it's actuallly John Walkenbach's web site:- http://j-walk.com/ss/excel/tips/tip53.htm Chip Pearson's page is very good too: http://www.cpearson.com/excel.htm