Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Can the default Cursor in 2016 be change back to an Arrow?

  1. #1
    Board Regular
    Join Date
    Dec 2013
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Can the default Cursor in 2016 be change back to an Arrow?

    I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow.
    Does anyone here know if it can be done. I want to make my pointer stay as a default Arrow instead of a cross when I'm working on my spreadsheets.

    Thanks in advance if you come up with this answer!

    Regards,
    U.S.

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,375
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    Alan Sidman
    Win 10--Office 2016

    Click below for a white paper on Data Base Design
    https://www.coursehero.com/file/8261...atabaseDesign/



  3. #3
    Board Regular
    Join Date
    Dec 2013
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    Thank you for your reply.

    However, where in excel do I change this default to a northwest arrow? It's value is number 1. I'm lost as to which tab in the ribbon or maybe under options to change this value. Any clue?

    I see it's in VB but why do I need to insert a module to just change the default for the cursor there?
    I tried it but doesn't seem to work...
    o
    Last edited by Ultimate Selector; Oct 4th, 2018 at 12:18 AM.

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    15,835
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    I think it can only be enforced by VBA
    Try this for the Nw arrow

    Code:
    Sub ChangeCursor()
      Application.Cursor = xlNorthwestArrow
     End Sub
    Otherwise it needs to be done via control panel and that will affect ALL applications
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  5. #5
    Board Regular
    Join Date
    Dec 2013
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    Quote Originally Posted by Michael M View Post
    I think it can only be enforced by VBA
    Try this for the Nw arrow

    Code:
    Sub ChangeCursor()
      Application.Cursor = xlNorthwestArrow
     End Sub
    Otherwise it needs to be done via control panel and that will affect ALL applications
    Thank You but that does not work for me as well. You would think they would make this a simple option to do. It can't be that hard can it? It must be cuz I can't find the answer anywhere. All I wanna do is just have an arrow cursor as a default!!!

  6. #6
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    15,835
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    you have tried changing it in the Control Panel, haven't you ??
    Control Panel>>Mouse>>Pointer tab>>change to suit.

    Obviously it is (that hard) !!
    Do you have the Developer tab on you Excel 2016 ?
    If so select that tab>>Click on Visual Basic>>Dbl click "This workbook" in the LH window
    Paste the code I provided in the RH pane where the cursor is flashung>>In the toolbar press the "run" arrow
    Cursor should now be NW arrow
    Last edited by Michael M; Oct 4th, 2018 at 12:46 AM.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  7. #7
    Board Regular
    Join Date
    Dec 2013
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    Thanks Mike ...

    I always have my NW arrow except when I'm in Excel. I tried what you said and I just can't seem to make it work.
    Your help has been much appreciated!

  8. #8
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    15,835
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    OK....the obvious eluded me !!!
    File >> Options>> Advanved>>Editing options>> Check the box that says "Enable fill handle and cell drag and drop"
    If that don't work....I'm off to the bar !!!
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  9. #9
    Board Regular
    Join Date
    Dec 2013
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can the default Cursor in 2016 be change back to an Arrow?

    Quote Originally Posted by Michael M View Post
    OK....the obvious eluded me !!!
    File >> Options>> Advanved>>Editing options>> Check the box that says "Enable fill handle and cell drag and drop"
    If that don't work....I'm off to the bar !!!
    I did that plus it was checked already anyways. But again Thanks!

    Hey have one .. no, no make it two for me while yur at it! Heh-Heh

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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