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

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
108
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. :cool:
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
108
Last edited:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
17,975
Office Version
2013
Platform
Windows
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
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
108
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!!!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
17,975
Office Version
2013
Platform
Windows
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:

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
108
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!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
17,975
Office Version
2013
Platform
Windows
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 !!!
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
108
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 :cool:
 

Forum statistics

Threads
1,078,462
Messages
5,340,456
Members
399,376
Latest member
Tresfjording

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top