How to Make OOo Calc with an Expire Date?

[Mahogan]

My goal to make a spreadsheet expire after a certain date, say 30 days, and have a user enter a password to be able to open it after that date. Then have it reset to another 30 days and require a new password for the next expiration date and so on. This may not be possible, however, I did find that you can set a sheet to expire in Excel.

See below:

Type the code that makes the spreadsheet expire into the code box provided. A proper code format that provides users with a message regarding the expiration date and the number of days left until the spreadsheet expires looks like this:

Sub Auto_Open()\ Dim exdate As Date \ exdate = "12/01/10" \ If Date > exdate Then \ MsgBox ("Spreadsheet has Expired") \ ActiveWorkbook.Close \ End If \ MsgBox ("Workbook Valid Until" & exdate - Date & "Days left") \ End Sub

Enter the date that the spreadsheet should expire by "exdate=" and any message you prefer regarding the expired worksheet in the place of "Spreadsheet has Expired."

Here is the full context:
http://www.ehow.com/how_5916660_make-excel-spreadsheet-expire.html


Does anyone know how to get this to work in OOo Calc?

Any help is appreciated.

[Villeroy]

All I know is how to bypass auto-open in Excel and Calc.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

[Mahogan]

I see a similar post to make formulas obscure after a certain date.

http://www.oooforum.org/forum/viewtopic.phtml?t=74795&highlight=expire

However, I do not understand how to use it properly, I keep getting error 508 or Name?

where you have <your_calculation> do you reference the cell that you want the NA or do you actually put in the formula? I have tried both and neither work.

[JohnV]

You can put this macro in the document then use Tools > Customize > Events tab to tie it to the "Open Document" event.

[Mahogan]

Thanks JohnV, that does work quite well for the initial 30 days expire time. Now the next challenge is how to get it to ask for a unique password that would at the same time reset the expire date to an additional 30 days and so on...

[Villeroy]

This is not a stand-up coder competition. You are not able to apply simple spreadsheet formulas while begging others to write program for you with constantly changing requirements.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

[Mahogan]

Villeroy that is quite an attack! Too bad you feel that way.

As my post initially read