Reminder OKonly button when spreadsheet opens

K

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
 
J

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
 
Top