How do i add a function button to a worksheet?
 

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!

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!

How do i add a function button to a worksheet?
 

You can use WEEKNUM function to get the week number and then create
PIVOTTABTLE.

It takes two parameters, one is a date (or a reference to a cell with the
date) and one is an offset for what day the week should start on [1 for for
Sunday and 2 for Monday respectively.] Heres what the function may look
like on your spreadsheet:

=WEEKNUM(A2,1)

It is part of "Analysis Toolpak'

To enable it
Under the €œTools€� menu, select €œAdd-Ins€¦€�
Under the resulting pop-up dialog, check the €œAnalysis ToolPak€� and press
€œOK€�.

"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!

How do i add a function button to a worksheet?
 

You may be better off creating a Template.

Users would open a workbook based on that Template and save as a new name.

The Template itself never gets changed and remains as is for next user.


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 19:33:00 -0700, 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!