Omgili, forum search, forums search, search forums, discussion search,discussions search, search discussions, board search, boards search, search boards
  Advanced Search

How would I add a reminder to a cell

On Wed, 29 Oct 2008 17:49:26 -0000, "BTDTGTTS" <none

My wife produces a simple timesheet for her 10 staff.
She *always* forgets to alter the week ending date and prints out the new
spreadsheet with the last weeks date on it then moans that she's missed it
again !

Is there a way I can add an automatic reminder to the cell for the date in
the sheet that she has to change the date to the new week before moving on
to change other data?

Thanks in advance



On Wed, 29 Oct 2008 15:09:51 -0300, "Bernard Liengme" <...@stfx.TRUENORTH.ca

How would this be:
Use View | Toolbars to show the Drawing Toolbar
Add a textbox (or a shape like a heart ?) and add some nice text to remind
the lady
Right click the shape and use Format Shape (textbox); open the Properties
tab and uncheck "Print Object"
Now position the reminder in a good place
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"BTDTGTTS" <...@bt.com...


On Wed, 29 Oct 2008 18:28:52 -0000, "BTDTGTTS" <none

"Bernard Liengme" <...@TK2MSFTNGP03.phx.gbl...

Such a simple idea.........Many thanks


On Wed, 29 Oct 2008 19:01:01 -0700, ShaneDevenshire <...@discussions.microsoft.com

Hi,

Another possibility, is to put a comment in one of the cells where she will
enter data. When she clicks on the cell the comment will be displayed.

Right-click a cell and choose Insert Comment. Enter a little reminder.

--
Thanks,
Shane Devenshire

>

On Thu, 30 Oct 2008 18:15:55 -0000, "BTDTGTTS" <none

"ShaneDevenshire" <...@discussions.microsoft.commessage news...@microsoft.com...

Cheers Shane,

The problem is that she dives into changing rota hours and ignores the date
cell.
It's a minor irritation but *every* time it means the bloody spreadsheet has
to be printed twice !

I have added a non-printing box as per Bernards suggestion and it is large
enough for me to read from over 30 ft away easily....Now we'll see if the
daft moo remembers the date next week ;-)


Discussion Title: How would I add a reminder to a cell
Title Keywords: would  reminder  cell