clearing a drop down menu entry
 

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.

clearing a drop down menu entry
 

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

"possum b" wrote in message
...
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.

clearing a drop down menu entry
 

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
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.