View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default How do i add a function button to a worksheet?

You can record a macro and do the cleanup... then assign the macro to a
button through Tools|Customize|toolbar|New

"TammyMarie" wrote:

I am creating a worksheet that is used by other users. New data is entered
on a weekly basis. This worksheet contains formulas. When the other users
delete the old data to enter the new data, they delete the formula aswell. I
would like to add a 'Clear Page' button so the formulas will not be deleted.
Could someone please help me with this.

Thank you!