Worksheet open events

[krissz]

I have an excel application which automatically updates from over 50 files when it is opened. Recalculation seems to occur each time a sheet is refreshed, which makes opening rather lengthy.
I know I can use an event (Worksheet_Open I believe) to turn off automatic recalculation, but what can I use to turn it back on again ?
Also, where should any such proceedures be placed ?

 

[pedie]

How does your code look like?

 

[krissz]

For dealing with this, there is no code. Each set of data is imported into a seperate excel sheet using the standard options available from the dat menu; they are then set to automatically update when the application is opened.
The code that exists deals entirely with other aspects of the application, namely data handling & processing plus the reports.
I have asked as I have no experience in this sector - I am looking for a way to disable calculation (easy) & then re-enable it (how ?).