Are you sure it's not being activated? Put a "stop" command into the sub as
well and see if it triggers the debugger.

If it's not being run, it might be in the wrong  module/ It needs to be in
the ThisWorkbook module.

If it is being run, but nothing appears to change, then you probably also
need an Application.MoveAfterReturn statement.

I tried the "stop" but nothing triggered.
The code  is not in the ThisWorkbook Module. I have not come across
ThisWorkbook. How do I access this ?

: I tried the "stop" but nothing triggered.
: The code  is not in the ThisWorkbook Module. I have not
: come across ThisWorkbook. How do I access this ?

Press Control+R to open  the Project Explorer window.
If nothing happens this window is already open. Scroll
down to VBAProject(Name), where "Name" is the name of
your workbook. Click on the plus sign to expand the
folder and double click on ThisWorkbook.

: 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.