F9 Button Macro

Is it possible to make a button which acts as an alternative for pressing F9
to create new random variables?

If yes, how do I go about it?

F9 recalculates.

You could add a button from the Forms toolbar to a worksheet.

Assign it this macro:

Option explicit
sub myRecalc()
application.calculate
end sub



Andrew McLeod wrote:
>
> Is it possible to make a button which acts as an alternative for pressing F9
> to create new random variables?
>
> If yes, how do I go about it?

--

Dave Peterson

Toolsw>Customize>Commands>Tools

There are two buttons available.

Calculate Full.........calcs all sheets

Calculate Now.........same as F9 calcs sheet.

Drag to Toolbar.


Gord Dibben Excel MVP

On Wed, 23 Nov 2005 10:37:16 -0600, Dave Peterson <[email protected]>
wrote:

>F9 recalculates.
>
>You could add a button from the Forms toolbar to a worksheet.
>
>Assign it this macro:
>
>Option explicit
>sub myRecalc()
> application.calculate
>end sub
>
>
>
>Andrew McLeod wrote:
>>
>> Is it possible to make a button which acts as an alternative for pressing F9
>> to create new random variables?
>>
>> If yes, how do I go about it?