Super

To delete all but formulas you don't need a macro, but you can record yourself
doing the following steps and produce a macro that you can assign to a button.

ToolsMacroRecord New Macro. Store macro in: This workbook. You can give it
a name and a shortcut combo if desired.

EditGo ToSpecialConstants. You can un-check what you want to find on the
sheet(text, numbers, etc.) or just leave all checked.

OK your way out then EditClearContents.

Formulas will remain ready for new data input.

Gord Dibben XL2002

On Fri, 21 Nov 2003 20:34:44 -0600, SuperJudge
wrote:


I have recently taken a 2 day course on basic Exel but it did not cover
anything about macros. I use a spreadsheet to keep track of paying
bills each month and I have seen (at my workplace) that you can insert
a button on the speadsheet that once clicked on will delete any
information typed and leave the spreadsheet with the formulas in tact.
Any ideas on how I could do this would greatly be appreciated.

Thanks,
SuperJudge :D


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/