Updateing worksheets when openening workbook
 

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

Updateing worksheets when openening workbook
 

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