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!