Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorksheetsEnableCalculation
Help the village idiot here.
Am trying to keep a large worksheet from calculating with the other sheets in the workbook. Worksheet named "Bob" has no cells in other sheets that are dependant on it. It simply collects data & does calculations. I have this little code for "Bob" Private Sub Worksheet_SelectionChange(ByVal Target As Range) Worksheets("Bob").EnableCalculation = True End Sub and this for the other sheets: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Worksheets("Bob").EnableCalculation = False Worksheets("Ted").EnableCalculation = True End Sub if i go to "Bob" and calculate, then go to any other sheet, the first time i hit enter, it recalculates every thing, including "Bob". Subsequent entries do not. Why? Related question - is there any way to do this little bit of code so i don't have to edit it every time a sheet is added or deleted? |