How do I revert cells to blank automatically on spacific days?

C

Conker10382

Does anybody know of a function, formual, or macro on Excel 2003 that I can
use so that my spreadsheet will automatically erase information in certain
cells on certain days? For example: On May 25th I will enter "YES" in cells
B5 and B6. I want cell B5 to automatically revert to a blank cell on June
5th and cell B6 to revert to a blank cell on June 11th. There aren't many
things that you can NOT do with Excel. Did I find one?
 
D

Don Guillett

No. You could put a procedure in your workbook_open event

if date=sheets("yourmastersheet").range("a1") then _
sheets("sheettochange").range("b5")=""
 
C

Conker10382

Don,
Thanks for the speedy reply. Unfortunately I am a master at Formulas and
Functions, but Macros are new territory for me. I don't expect you to take
up your day explaining to me how to enter a procedure in my workbook_open
event (unless it's really simple). Is there a training course offered by
Microsoft that could teach me this? When it comes to Excel, I'm willing to
learn everything there is to know.
 
D

Don Guillett

right click the excel icon in the upper LEFT of your screen next to
FILE>view code>play around
 
C

Conker10382

Thanks Don, you're suggestions worked great!

Don Guillett said:
right click the excel icon in the upper LEFT of your screen next to
FILE>view code>play around
Click to expand...
 
Top