Timeout-Lockout capability

J

Jim JBC

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.
 
B

bob777

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.
 
J

Jim JBC

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...
 
Top