View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bob777
 
Posts: n/a
Default Timeout-Lockout capability


Put conditional formatting on all the cells that calculate values,
choosing black font and black shading that comes into play when
"today's date" is greater than a nominated date. The cell with the
nominated date in it would be locked, black font, black shading. Lock
all the "potentially black" cells and password protect the sheet. Users
would be able to put in their own data to try out the spreadsheet, but
after the specified date all key cells would turn black.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=487470