F9 Button Macro

A

Andrew McLeod

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

Dave Peterson

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
 
G

Gord Dibben

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
 
Top