| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a macro that runs automatically when a workbook is opened
i am trying to write a macro which will turn on Iteration whenever a workbook
is opened, i have written the following: Private Sub Workbook_Open() With Application .Iteration = True .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub and it doesnt work, would you know why? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
a macro that runs automatically when a workbook is opened
Make sure you have installed the macro in the workbook code area and not a
standard module. -- Gary''s Student - gsnu200860 "david netser" wrote: i am trying to write a macro which will turn on Iteration whenever a workbook is opened, i have written the following: Private Sub Workbook_Open() With Application .Iteration = True .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub and it doesnt work, would you know why? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
a macro that runs automatically when a workbook is opened
many thanks, it worked perfectly. david
"Gary''s Student" wrote: Make sure you have installed the macro in the workbook code area and not a standard module. -- Gary''s Student - gsnu200860 "david netser" wrote: i am trying to write a macro which will turn on Iteration whenever a workbook is opened, i have written the following: Private Sub Workbook_Open() With Application .Iteration = True .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub and it doesnt work, would you know why? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that runs automatically? | Excel Programming | |||
| Macro that runs automatically? | Excel Programming | |||
| Macro that runs automatically? | Excel Programming | |||
| Excel Workbook automatically (by design) runs a macro | Excel Programming | |||
| Excel Workbook automatically (by design) runs a macro | Excel Programming | |||
Hybrid Mode
