Activating a Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

d_kight - 29 Jun 2006 18:19 GMT

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

Reply to this Message

Bondi - 29 Jun 2006 18:28 GMT

> How do I activate this Macro?
>
[quoted text clipped - 6 lines]
>
> 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

Reply to this Message

d_kight - 30 Jun 2006 19:36 GMT

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

> > How do I activate this Macro?
> >
[quoted text clipped - 15 lines]
> Regards,
> Bondi

Reply to this Message

CLR - 30 Jun 2006 19:46 GMT

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

Vaya con Dios,
Chuck, CABGx3

> thanks you guys, I will give this a go and see what happens. I am really new
> to programming with Macros.
[quoted text clipped - 23 lines]
> > Regards,
> > Bondi

Reply to this Message

CLR - 29 Jun 2006 18:29 GMT

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

Vaya con Dios,
Chuck, CABGx3

> How do I activate this Macro?
>
[quoted text clipped - 6 lines]
>
> Dan

Reply to this Message

Seeking help - 30 Jun 2006 09:43 GMT

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

Reply to this Message