Is there a way to clear entries made by a drop down list?
I would like to clear 5 cell entries when the sheet is opened and by
selecting the master cell in worksheet.

A better explanation or
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"possum b" <(E-Mail Removed)> wrote in message
news:0033D008-3A02-4C7B-A3B6-(E-Mail Removed)...
> Is there a way to clear entries made by a drop down list?
> I would like to clear 5 cell entries when the sheet is opened and by
> selecting the master cell in worksheet.

Sheet is activated or workbook is opened?

Which 5 cells would you like cleared?

What is the "master cell"?


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 14:05:01 -0800, possum b
<(E-Mail Removed)> wrote:

>Is there a way to clear entries made by a drop down list?
>I would like to clear 5 cell entries when the sheet is opened and by
>selecting the master cell in worksheet.