View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laidebug laidebug is offline
external usenet poster
 
Posts: 6
Default pop up box reminder

How do I make a pop up box appear, upon opening a spreadsheet, that reminds
the user to "change the date" in the spreadsheet? I have statistical
spreadsheets that calculate data based on the monthend date and several
collectors of the information forget to change the date. Not such a bad thing
because I can always change it when it's emailed to me.....the problem lies
when the user prints and distributes data that is not correct becasue of the
date. I thought a pop up box would help.....or do you have any other ideas?
Or is there a way to open the spreadsheet and have the curser stuck on a
specific cell and it will not move until a date is entered? Thanks!