Button in a toolbar to insert a specific function

  • Thread starter Thread starter catherine
  • Start date Start date
C

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.
 
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
 
Thanks Jeff

I will try it

Catherine
Jeff said:
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
Click to expand...
 
Back
Top