View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] anand288@hotmail.com is offline
external usenet poster
 
Posts: 3
Default Starting a Makro automatically

Hello,

I would like to run a Macro automatically after opening a Workbook, to
set the "Iteration" Option.

I found the following code :
Private Sub Workbook_Open()
Application.Iteration = True
End Sub

However I can't get Excel to start this macro when the workbook gets
opened. I have to start the macro manually.

All help would be graetly appreciated.

Cheers,
Anan dPatel