how to execute a macro automatically
 

can the answer be posted here so others can read it , please

Ro

how to execute a macro automatically
 

In a general module:

Sub Auto_open()
End sub


HTH
--
AP

"Roger" a écrit dans le message de news:
...
can the answer be posted here so others can read it , please

Ro

how to execute a macro automatically
 

"Roger" wrote in message
...
can the answer be posted here so others can read it , please

Wouldn't do it any other way.

In response to the question

Private Sub Workbook_Open()
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code