OK

If I understand correctly, try something like this,

Record a marco – Tools Macro Record new macro

Macro1 Select store in this workbook, then OK

Click cell A1, input =RAND()
Click cell B1, input =RAND()

Stop marco recording

Now record macro2

Record a marco – Tools Macro Record new macro

Macro2 Select store in this workbook, then OK

Click cell A1, input 0
Click cell B1, input 0

Stop marco recording

Now - View Toolbars Forms

Click on the "button" icon and draw one on your spreadsheet (Button 1),
the Assign macro box opens – select Macro1 OK

Now do the same for Macro2

Click button 1 for random numbers
Click button 2 for 0’s

oldchippy


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=566384