Hi,

I would like Excel sheet to work for a certain period of time say like 30 days or so from the date its 1st used by someone, the issue are as below:

a) I can ask the macro to check the date the sheet is 1st open and the copy and paste value and then count 30 days from it every time it open however if someone change the computer date it can work still.

b) I would like the sheet to be valid for a particular duration say from 1st April of one year to 31st of the following year (Indian Accounting period), no idea how to do this.

c) presently at the start of excel sheet a user form ask for user name and pass key to check his authorization to use and rights he have as detailed above I would like to check user right to use also ie how many days remained etc.


I will be happy if anyone can help on Point B as i will probably will go that way.

Note: in case of Option B Excel must not accept any date before and after the given date, I agree that can be done by giving validation but still if something better can be suggested.

Thanks in Advance.

Reg,
CVishu

(I am not using any other user form)