Activating a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
d_kight said:
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
Click to expand...

Hi Dan,

Try ALT+F8 and then chose "sigma_to_cell"

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

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

Vaya con Dios,
Chuck, CABGx3
 
Something it can also be the macro security.
Go to tool>Macro>security and set it to medium
 
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
 
Back
Top