Button in a toolbar to insert a specific function

[catherine]

Hi,

Is it possible to have a shortcut in my Menu to insert a specific function
without going through the list or selecting it when I ckick on Insert -
Function.

I know how to customize my toolbar, but I want a button for the COS function
for example.

I have Excel 2003 SP3

Thanks.

 

[Jeff]

Hi Cathrine,
place this pocedure in your personal.xls

Public Sub getCosine()
On Error Resume Next
ActiveCell.Value = "=COS(" & ActiveCell.Value & ")"
End Sub

Add your new control as usual and assign this macro to it.

If you haven't used your personal.xls before have a look here.

http://www.rondebruin.nl/personal.htm

HTH

 

[Catherine]

Thanks Jeff

I will try it

Catherine

Hi Cathrine,
place this pocedure in your personal.xls

Public Sub getCosine()
On Error Resume Next
ActiveCell.Value = "=COS(" & ActiveCell.Value & ")"
End Sub

Add your new control as usual and assign this macro to it.

If you haven't used your personal.xls before have a look here.

http://www.rondebruin.nl/personal.htm

HTH