AndrewKent
Well-known Member
- Joined
- Jul 26, 2006
- Messages
- 889
I'm looking to add a form button onto quite a large Excel document that will calculate the active worksheets. I'm using this code but it doesn't appear to be calculating all the worksheets. Can anyone offer an alternative
Andy
Code:
Sub CalculateWorkbook()
Dim wks As Worksheet
Application.Calculation = xlManual
For Each wks In ActiveWorkbook.Worksheets
wks.Calculate
Next
Set wks = Nothing
End Sub
Andy