+ Reply to Thread
Results 1 to 9 of 9

Removing snap to shape

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Removing snap to shape

    I am trying to use line shapes to create a scale on a meter for a dashboard.
    When near another shape my line snaps to it. I have turned off snap to shape and snap to grid to no avail. Is there anything else I can do?
    John

  2. #2
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Removing snap to shape

    Are there no ideas to guide me on my way? I have discovered that it is only lines that don't obey the don't snap to shape command.
    John

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,907

    Re: Removing snap to shape

    I can't reproduce that at all. Can you post a workbook that shows that?

  4. #4
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Removing snap to shape

    I have copied a trial version for you. A difficult line is the blue one on the left hand 60%. Generally if there is a shape point near then one end of the line will grab it. The defining points of the arc shape are mostly at the ends so a lot of the scale marks were easy to position, but not the end ones.
    John
    Attached Files Attached Files

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,907

    Re: Removing snap to shape

    I still can't replicate that. I can put that blue line anywhere at all with no problems. What build of 2010 do you have?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Removing snap to shape

    Try using a freeform shape rather than a connector.

    It's not snapping to grid but it is snapping to connection points and turning if off has no effect.
    Cheers
    Andy
    www.andypope.info

  7. #7
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Removing snap to shape

    Andy,
    I am using an arc and a line. Are you saying that if I drew the arc freehand (if I can) then I would not have the problem?

    John

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Removing snap to shape

    Start by drawing the line using freeform and test whether snapping still occurs.

  9. #9
    Registered User
    Join Date
    02-13-2020
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    1

    Re: Removing snap to shape

    Same problem for me. It keeps snapping. I am using rectangles and lines. I don't want to draw any freeform. Yet, it keeps snapping the line to the 1/2 point on the side of the rectangle or the corner.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vba to snap to grid
    By NickyC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2015, 01:08 PM
  2. [SOLVED] Snap to grid in Excel
    By Maria Moreno in forum Excel General
    Replies: 0
    Last Post: 10-16-2015, 08:47 AM
  3. help - snap to grid
    By elchiefo in forum Excel General
    Replies: 2
    Last Post: 07-10-2014, 08:04 AM
  4. Snap to grid
    By MK21 in forum Excel General
    Replies: 3
    Last Post: 07-08-2013, 05:57 PM
  5. Snap to Shape On/Off
    By Joakim N in forum Excel General
    Replies: 0
    Last Post: 08-14-2012, 08:41 AM
  6. Snap view to a shape?
    By Cheshire in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2010, 12:47 PM
  7. Snap Shot
    By bray2cool in forum Excel General
    Replies: 1
    Last Post: 07-22-2007, 05:57 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1