Activating a Macro

D

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
 
B

Bondi

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
S

Seeking help

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does one change the font name with VBA? 0
Macro Loop 0
Remove numbers from brackets 0
Making a macro only work on certain files 2
Trying to remove error from conflicting code 0
Change a great number of words in word files, with a macro as short as possible. 5
Mail Merge Switch - Dollars to Words 0
Convert old wordbasic code into VBA that will run now 0

Top