Button in a toolbar to insert a specific function
 

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.

Button in a toolbar to insert a specific function
 

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" wrote:

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.

Button in a toolbar to insert a specific function
 

Thanks Jeff

I will try it

Catherine
"Jeff" a écrit dans le message de
...
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" wrote:

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.