Macros And Buttons
 

If anyone has been through this same problem please help. I have
created two macros and corresponding buttons on the toolbar, but when i

send the file the toolbar buttons do not stay and i do not know why it
would be great to get some help with this. Also is it possible to
create those buttons for the macros and put them into cells?

Macros And Buttons
 

You could create a new toolbar and stick the buttons on that.

Then attach the toolbar to the workbook uisng ToolsCustomizeToolbars.

Alternatives...................

You can place buttons on the worksheet using the Forms Toolbar.

Any object can have a macro assigned to it.,

Wordart, a picture, a drawing from the Drawing toolbar.......as I stated.....any
object that can be placed on a worksheet can be a button for a macro.


Gord Dibben MS Excel MVP

On 8 Aug 2006 13:22:52 -0700, wrote:

If anyone has been through this same problem please help. I have
created two macros and corresponding buttons on the toolbar, but when i

send the file the toolbar buttons do not stay and i do not know why it
would be great to get some help with this. Also is it possible to
create those buttons for the macros and put them into cells?

Macros And Buttons
 

Hi

You can add buttons from the Forms or Control toolbox on your sheet a
nd assign your macro's to it.

Or attach a custom toolbar that you create to the file
ViewToolbars..Customize
Use the Attach button after you create the toolbar and save the file



--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message ps.com...
If anyone has been through this same problem please help. I have
created two macros and corresponding buttons on the toolbar, but when i

send the file the toolbar buttons do not stay and i do not know why it
would be great to get some help with this. Also is it possible to
create those buttons for the macros and put them into cells?

Macros And Buttons
 

Do you think you could walk me through the custom toolbar option
Ron de Bruin wrote:
Hi

You can add buttons from the Forms or Control toolbox on your sheet a
nd assign your macro's to it.

Or attach a custom toolbar that you create to the file
ViewToolbars..Customize
Use the Attach button after you create the toolbar and save the file



--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message ps.com...
If anyone has been through this same problem please help. I have
created two macros and corresponding buttons on the toolbar, but when i

send the file the toolbar buttons do not stay and i do not know why it
would be great to get some help with this. Also is it possible to
create those buttons for the macros and put them into cells?

Macros And Buttons
 

Hi

ViewToolbars..Customize
Click on New and name it
The toolbar is on your screen now
Click on commands
Drag the buttons you want to the toolbar (Macro's :custom button)
You can rightclick on the button and assign a macro to it and change the button image
Click on Toolbars and on Attach and add it to your workbook
Save the file



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi

You can add buttons from the Forms or Control toolbox on your sheet a
nd assign your macro's to it.

Or attach a custom toolbar that you create to the file
ViewToolbars..Customize
Use the Attach button after you create the toolbar and save the file



--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message ps.com...
If anyone has been through this same problem please help. I have
created two macros and corresponding buttons on the toolbar, but when i

send the file the toolbar buttons do not stay and i do not know why it
would be great to get some help with this. Also is it possible to
create those buttons for the macros and put them into cells?