CODEWITHSUNDEEP
excelvba
juergen d
juergen d

Reputation: 204746

Rerun all VBA function when worksheet opens

I have an Excel macro file (.XLSM) with multiple sheets in it.
In the first sheet in every row are some functions defined.

Example:
Cell A2 is

=checkSomething(A2)

which puts an X in the cell if the conditions are true and an empty string otherwise.

The checkSomething function checks cells in other worksheets.

When I change the data in the other worksheets and come back to the first sheet then the functions do not run again. The X is not recalculated. How to do that?

Upvotes: 0

Views: 658

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

Try including the following in the workbook code area:

Private Sub Workbook_Open()
    Application.CalculateFullRebuild
End Sub

Upvotes: 3

Related Questions