Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Activating a Macro
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Activating a Macro
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Activating a Macro
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Activating a Macro
Something it can also be the macro security. Go to toolMacrosecurity and set it to medium. -- Seeking help ------------------------------------------------------------------------ Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658 View this thread: http://www.excelforum.com/showthread...hreadid=557019 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Activating a Macro
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Activating a Macro
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |