Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to get excel to turn to manual calculation for any workbook used.
I thought I could use an add-in to create an automatic procedure with the workbook open event, in order to make it generic: Sub Workbook_Open() If Application.Calculation = xlCalculationAutomatic Then Application.Calculation = xlCalculationManual End Sub However, this seems to work only on individual workbooks since the add-in doesn't perform any action when I open a random workbook. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AutoCalc Worksheet in ManualCalc Workbook | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
How to see if the opened workbook is opened by another user ? | Excel Programming |