Good morning Lewis Koh
This code will do the trick.
Sub Mod1()
If Range("A12").Value = 1 Then
Range("A1:B5,A7:B11").Clear
End If
End Sub
Copy it into a blank module, and draw yourself a button using the Forms
toolbar, when you've created your button right click it, and select
assign macro, and select Mod1 (or whatever you've chosen to call it).
HTH
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=391513