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

ToolswCustomizeCommandsTools

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
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?