Thread: F9 Button Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default F9 Button Macro

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