I want to create some 'demos' of spreadsheet tools I use to give people
the capability to 'test drive' them for say 30 days and after that,
lock them out unless they 'subscribe' or get a different password to
unlock the workbook. Is this possible, how easy/hard? Any sample code
anyone has?

Thanks in advance.


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

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

Thanks, I'll try it out. Any other posts will be accepted an dtried as
well. There is usually more than one way to skin a cat...


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