Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

active cell no longer advances to cell below

  Asked By: Kaua    Date: Dec 06    Category: MS Office    Views: 1038
  

I ran someone else's macro, and now when I hit "return", my
active cell no longer advances to the cell below, as it usually does.

Does anyone know where this behavior is set?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Blas Fischer     Answered On: Dec 06

Tools|Options, Edit tab, 'Move Selection after Enter' & 'Direction'

 
Answer #2    Answered By: Tara Ryan     Answered On: Dec 06

If you check "someone else's macro", you'll probably find a method called
MoveAfterReturn or MoveAfterReturnDirection where your settings were
changed.

Pascal's instructions for:
Tools|Options, Edit tab, 'Move Selection after Enter' & 'Direction'
are how you can change it back without the macro.

If the macro  is going to continue to be used, I'd suggest storing current
settings
at the beginning, then restore them at the end.

 
Didn't find what you were looking for? Find more on active cell no longer advances to cell below Or get search suggestion and latest updates.




Tagged: