button on toolbar

[Guest]

dear all,
i created a button on worksheet but after sometime the button is
moving and not at its orignal place. this could be user delete or
insert columns on the worksheet.
may i know if there is a way or how to move this button and put in
toolbar? if need to write vba or macro, can show me the script as
well.
thanks alot

 

[Gord Dibben]

Mango

Tools>Customize>Commands.

Scroll down to Macros and select. You will be shown a smiley-face.

Drag it to your Toolbar. You can right-clck and "Assign Macro".

You can also change the Icon by right-click and "Edit button image" or "Change
button image".

For the second part of your question.........we cannot show you the script of
a macro if we don't know what you want it to do.

Try Tools>Macro>Record New Macro.

Record your steps and assign this macro to the button above.

For more on getting started with macros se David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP