George J
Well-known Member
- Joined
- Feb 15, 2002
- Messages
- 959
I have the following code to switch the sheet calculation from Manual (done to speed up another macro - copy & paste lots of detail from other sheets), to Automatic.
I am not sure how to go about it, but am sure the onkey command is correct.
Private Sub Worksheet_calculate()
Application.OnKey "{F12}", "Calculate_Auto"
End Sub
Any tips appreciated.
I am not sure how to go about it, but am sure the onkey command is correct.
Private Sub Worksheet_calculate()
Application.OnKey "{F12}", "Calculate_Auto"
End Sub
Any tips appreciated.