Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute Upon Opening
When I open up one particular file (that has data tables), I would like a macro to immediately tell EXCEL that I want to temporarily alter my normal default setting which is auto recalc, in favor of auto recalc without data tables. Can this EXCEL setting be changed by a macro that automatically launches when this file is opened? Here is the macro I pasted (I didn't create it per se, in case it matters) into the "This Workbook" object, but it doesn't seem to be working.
Private Sub Workbook_Open() With Application .Calculation = xlSemiautomatic .MaxChange = 0.01 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub Thanks much! Dean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Execute macro at opening file | New Users to Excel | |||
Execute C++ from Excel | New Users to Excel | |||
How to Write a sub to execute the following | Excel Programming | |||
Could not execute | Excel Worksheet Functions | |||
Execute program (macro?) upon opening a workbook | Excel Programming |