Hi, at the beginning sorry for my English
My workbook include several worksheets. The main one is named "data" and inside of it I have Worksheet_SelectionChange event. Other worksheet do not contain any makros, only vlookup functions (about several thousands of them).
At the beginning of SelectionChange event I turn on xlCalculationManual. MsgBox Application.Calculation return -4135, so it looks like works correctly...but every time when I change value of any cell in worksheet 'data', excel calculate whole workbook - I think excel do it, because it takes several second to change the value. When I delete all worksheets (besides 'data' of course) everything starts working rapidly.
Bookmarks