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

Ro

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

"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