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 |