Activating a Macro

[d_kight]

How do I activate this Macro?

Sub sigma_to_cell()
Selection.Font.Name = "Symbol"
Selection.Value = "S"
End Sub

Any help is greatly appreciated.

Dan

[Bondi]

d_kight wrote:
> How do I activate this Macro?
>
> Sub sigma_to_cell()
> Selection.Font.Name = "Symbol"
> Selection.Value = "S"
> End Sub
>
> Any help is greatly appreciated.
>
> Dan

Hi Dan,

Try ALT+F8 and then chose "sigma_to_cell"

It will place a the Sigma in the active cell(s)

Regards,
Bondi

[CLR]

Tools > Macro > Macros > select the macro by name in the large window and
press RUN

Vaya con Dios,
Chuck, CABGx3



"d_kight" wrote:

> How do I activate this Macro?
>
> Sub sigma_to_cell()
> Selection.Font.Name = "Symbol"
> Selection.Value = "S"
> End Sub
>
> Any help is greatly appreciated.
>
> Dan

[Seeking help]

Something it can also be the macro security.
Go to tool>Macro>security and set it to medium.

[d_kight]

thanks you guys, I will give this a go and see what happens. I am really new
to programming with Macros.

Any suggestions on how to get more training with using and becomming
familiar with visual Basic syntax?

thank you again

"Bondi" wrote:

>
> d_kight wrote:
> > How do I activate this Macro?
> >
> > Sub sigma_to_cell()
> > Selection.Font.Name = "Symbol"
> > Selection.Value = "S"
> > End Sub
> >
> > Any help is greatly appreciated.
> >
> > Dan
>
> Hi Dan,
>
> Try ALT+F8 and then chose "sigma_to_cell"
>
> It will place a the Sigma in the active cell(s)
>
> Regards,
> Bondi
>
>

[CLR]

http://www.mvps.org/dmcritchie/excel/excel.htm
www.cpearson.com
http://www.mcgimpsey.com/index.html

Vaya con Dios,
Chuck, CABGx3



"d_kight" wrote:

> thanks you guys, I will give this a go and see what happens. I am really new
> to programming with Macros.
>
> Any suggestions on how to get more training with using and becomming
> familiar with visual Basic syntax?
>
> thank you again
>
> "Bondi" wrote:
>
> >
> > d_kight wrote:
> > > How do I activate this Macro?
> > >
> > > Sub sigma_to_cell()
> > > Selection.Font.Name = "Symbol"
> > > Selection.Value = "S"
> > > End Sub
> > >
> > > Any help is greatly appreciated.
> > >
> > > Dan
> >
> > Hi Dan,
> >
> > Try ALT+F8 and then chose "sigma_to_cell"
> >
> > It will place a the Sigma in the active cell(s)
> >
> > Regards,
> > Bondi
> >
> >