MoveAfterReturn fails because sheet is protected

[Guest]

I am using Windows XP with Office 2003.
I have the following programs in a sheet module:

Private Sub Worksheet_Activate()
Application.MoveAfterReturn = False
End Sub
Private Sub Worksheet_Deactivate()
Application.MoveAfterReturn = True
End Sub

But, when the sheet is activated, the cell pointer still moves after enter.
This failure only occurs if the sheet is protected. I want it to work when
the sheet is protected.
How can I get this to work?

Thanks in advance for your assistance.

 

[Guest]

The code works fine on my machine... You mention that the code is in a sheet
module. Just to clarify... It is in a sheet? Not in a module.

Try putting break points on the procedures or put a message box in the
procedure just to make sure the events are firing.

Speaking of event firing... in your code anywhere do you toggle the

Application.enableevents = false

without setting it back.

Application.enableevents = true

If your events are off you are hooped and will have to reset them.

HTH

 

[Guest]

Jim,

Thanks for your reply. Events are not disabled anywhere in my code. The only
cells that are unlocked are those on a single row. It is strange that this
works if the sheet is not protected...