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.

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.

Thanks Jeff

I will try it

Catherine
"Jeff" <(E-Mail Removed)> a écrit dans le message de
news:2CA497B6-BB04-446C-8EE3-(E-Mail Removed)...
> 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.