: I am trying to activate  some code  when a workbook  opens.
: Code as follows:-
: 'Private Sub Workbook_Open()
: Application.MoveAfterReturnDirection = xlToRight
: End Sub'
: The code is not being activated on opening  the workbook.
: What am I doing wrong  ???

Which module did you place this code in? It should go
in the "ThisWorkbook" object under the Microsoft Excel
Objects folder.