Hi JudyP,
See how you get on with recording a macro
Tools Macro Record new macro
Macro1 Select store in this workbook, then OK
Click the cells you want to clear, then press the Delete key
Stop marco recording
Now - View Toolbars Forms
Click on the "button" icon and draw one on your spreadsheet (Button 1,
you can change this to "Clear"), the Assign macro box opens – select
Macro1 OK
Is this any help?
oldchippy :)
--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile:
http://www.excelforum.com/member.php...o&userid=19907
View this thread:
http://www.excelforum.com/showthread...hreadid=568664