Hi Aleks

You can use the workbook open event to close the workbook after a certain date

Private Sub Workbook_Open()
If Date DateSerial(2007, 1, 25) Then
ThisWorkbook.Close False
End If
End Sub


can input any more data till another spreadsheet
is available after data analysys.

You can also test with Dir if the other workbook is there before you close the file



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aleks" wrote in message ...
Hi Ron,

i want to force users to use the macro , and yes code is an option

Thanks


"Ron de Bruin" wrote:

Hi Aleks

You need code to do that.
If the user disable macro's it is possible to change the data

Is code a option ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aleks" wrote in message ...
Hi,

I need to setup my excell spreadsheet that is doing some calculations, in
such a way that after certain date ,(say 25/01/2007) the spread**** is going
to be rendered as disabled so that nobody (spreadseett wil be available
through LAN of my company) can input any more data till another spreadsheet
is available after data analysys.

Thank you