Reminder OKonly button when spreadsheet opens

[krislyn]

My secretary is asking if there's a way to remind her to change th
header in a spreadsheet weekly. I was thinking either a reminde
(Okonly) when the workbook opens, or a button that brings up the forma
so she can change it weekly?

Found help on displaying paths in footers, but this is changing th
date on the header for printing.
Thanks for any help!

krislyn
US

 

[Jason Morin]

You could insert a formula into a cell that displays on
every Monday:

=IF(WEEKDAY(TODAY())=2,"Update Header!","")

The "2" represents Monday. 1=Sun, 3=Tue, 4=Wed, etc.

HTH
Jason
Atlanta, GA

 

[krislyn]

Thanks Jason!!

krislyn;