Macro Buttons

AllenL · Apr 9th, 2002, 07:51 AM

Hello
I have some buttons for my macros in the workbook. However, when I distribute them to other people by e-mail. Those buttons are not there any more
Could someone please help me out

Thanks in advance

Al Chara · Apr 9th, 2002, 07:56 AM

Have you attached the toolbar to the worksheet?

Right click on a toolbar, goto customize, highlight your toolbar, and click attach.

AllenL · Apr 9th, 2002, 08:10 AM

If I have two buttons created in the standard toolbar. How can I attach those two buttons to the toolbar?

Thanks in advance

Al Chara · Apr 9th, 2002, 08:13 AM

If you are sending this workbook out to other users, then I recommend that you create a custom toolbar to hold your macro buttons.

Dave Hawley · Apr 9th, 2002, 08:17 AM

Hi Allen

RE: If I have two buttons created in the standard toolbar. How can I attach those two buttons to the toolbar?

Unless you use code you basically cannot. A Custom toolbar as Al suggests is normally the better option.

AllenL · Apr 9th, 2002, 09:48 AM

yes, custom toolbar is perfect
Thanks guys

Apr 9th, 2002, 07:56 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Have you attached the toolbar to the worksheet? Right click on a toolbar, goto customize, highlight your toolbar, and click attach. __________________ Kind regards, Al Chara

Apr 9th, 2002, 08:13 AM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	If you are sending this workbook out to other users, then I recommend that you create a custom toolbar to hold your macro buttons. __________________ Kind regards, Al Chara

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

Apr 9th, 2002, 07:51 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Hello I have some buttons for my macros in the workbook. However, when I distribute them to other people by e-mail. Those buttons are not there any more Could someone please help me out Thanks in advance

Apr 9th, 2002, 08:10 AM	#3
AllenL Board Regular Join Date: Mar 2002 Posts: 67	If I have two buttons created in the standard toolbar. How can I attach those two buttons to the toolbar? Thanks in advance

Apr 9th, 2002, 08:17 AM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Allen RE: If I have two buttons created in the standard toolbar. How can I attach those two buttons to the toolbar? Unless you use code you basically cannot. A Custom toolbar as Al suggests is normally the better option.

Apr 9th, 2002, 09:48 AM	#6
AllenL Board Regular Join Date: Mar 2002 Posts: 67	yes, custom toolbar is perfect Thanks guys