Make a Cell Act like a Button
you can use buttons from the controls tool box (left click on a tool
bar to bring up a list and tickm it),
Draw the button on the sheet, and then dobble click it,
between the code line wite the name of the macro you want to run
ie.
sub Command1_click
My_Macro
end sub
you can also draw a shap (from the drawing tool bar) on to a sheet and
asign a macro to this, left click and pick the "Assign macro" option
from the short cut menu.
here a tip, if you are doing this then you can protect the sheet, and
you will get a nice looking hand icon over the picture!
good luck
ross
|