Updateing worksheets when openening workbook

[a94andwi]

Hello.

How do I write a script that calculates all cells in a workbook when I open it?

[Jim Thomlinson]

Add this code to "ThisWorkbook"

Private Sub Workbook_Open()
Application.CalculateFull
End Sub

To get to thisworkbook right click the Excel Icon in the upper left corner
of the excel window and choose view code.
--
HTH...

Jim Thomlinson


"a94andwi" wrote:

>
> Hello.
>
> How do I write a script that calculates all cells in a workbook when I
> open it?
>
>
> --
> a94andwi
> ------------------------------------------------------------------------
> a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
> View this thread: http://www.excelforum.com/showthread...hreadid=384299
>
>