Peter,

The Workbook_Open goes into the ThisWorkbook module...

--
sb
"Peter Longstaff" wrote in message
. ..
"Tom Ogilvy" wrote in news:OtNqSOPaDHA.2632
@TK2MSFTNGP09.phx.gbl:

Private sub Workbook_Open()
if thisworkbook.Path = "" then
mymacro
End if
End Sub



Hi Tom,

thanks for this but i do not know where to place this function. DO I place
it in the workbook or the specific sheet ?

TIA
Peter