Adding a button with a function on protected sheets.

[Alchemist]

How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).

Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.

How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?

Thanks

 

[Anne Troy]

There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) where .... is your vlookup
formula.
2. Use a template that's blank already at the beginning of each day.
Some of this is convered under "error handling" at this article:
http://www.officearticles.com/tutorials/an_extreme_tutorial_in_microsoft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************