Page 1 of 3 123 LastLast
Results 1 to 15 of 38
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cursor moving to new cell location (2000)

    Hi,

    I have an unusual problem in that when l place todays date into a cell for some strange reason the cursor moves
    to a cell which is much further up the top of the screen. It is a little annoying having to keep moving the cursor down all the time to the cell where l have just placed the date.
    Any ideas as to what is causing this?

    see attachment.

    Regards
    Justin

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cursor moving to new cell location (2000)

    Do you have any macros in the workbook?

    I would suspect that you have one triggered by some event that moves you.

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    Is there any easy way of finding out as to where this particular macro is located.

    Apart from deleting each row until l come across it.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cursor moving to new cell location (2000)

    If you open the file with "macros disabled" does this problem occur?

    If it does not, you have a macro running causing the problem. YOu can look at the macros by going to VB (Alt-F11)

    Look in the "sheet" object for this sheet for any code, and the "thisWorkbook" object as well as any modules.

    Steve

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    Please can you tell me how l disable the macros also how can l look at the macros in VB.
    Where do l need to be looking?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cursor moving to new cell location (2000)

    Select Alt+F11 to activate the Visual Basic Editor.
    Press Ctrl+R to make sure that the Project Explorer is visible.
    You should see something like the screenshot below.
    Double click ThisWorkbook and the nodes corresponding to the worksheets to see the code, if there is any.

    A completely different possibility: if the worksheet has been protected, Tab will cycle through the unlocked cells in the worksheet. Select Tools | Protection. If the first item in the submenu is Unprotect Sheet, the worksheet has been protected.

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    I have done this but still cannot appear to find out where the macro is located.
    Can you tell me where to look?
    see attachment.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cursor moving to new cell location (2000)

    Double click the item corrsponding to the "problem" worksheet (Sheet1 or whatever.) A module window will open. If this contains no code, double click ThisWorkbook. Another module window will open. If this contains no code either, the problem is not caused by an event handler.

  9. #9
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    I can confirm the problem is not caused by an event handler.
    Do you have any further suggestions?.

    Justin

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cursor moving to new cell location (2000)

    Did you check my suggestion about a protected worksheet earlier in this thread?

  11. #11
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    Yes, the worksheet is not protected.

    Justin

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cursor moving to new cell location (2000)

    Out of ideas then. Could you post a stripped-down copy of the workbook? Remove all worksheets except the problem worksheet, and remove most data or replace them by dummy data. If it's too large, create a zip file and attach that. Please indicate which cell exhibits the strange behavior, so that we can test.

  13. #13
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    I am unable to attach a file as it is to large (even zipped up).
    Altough l have virtually removed all data from the spreadsheet but problem still exists.
    see attachment.

    Justin.

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cursor moving to new cell location (2000)

    A single worksheet with 100 rows and 10 columns or so can't be that big. Try copying the worksheet into a new, blank workbook and see if that is small enough.

  15. #15
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor moving to new cell location (2000)

    This problem appears to be resolved but l have an addtional problem.
    A bracket appears in the cell above the macro.
    see attachment.
    Do you still want me to send you the worksheet?

    Justin.

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •