Hide Border of Currently Active Cell
Results 1 to 3 of 3

Thread: Hide Border of Currently Active Cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Hide Border of Currently Active Cell

    I want to hide the thick black border with Fill Handle of the currently selected cell so that it isn't obvious that a particular cell is the active cell.

    I don't know VBA but am happy to use it if it does the job. I had seen a suggestion of using

    ActiveSheet.EnableSelection = xlNoSelection

    but I don't know how to implement this and the appropriate code to surround it.

    Does anyone have any suggestions... or alternative ways to achieve this?

    Many thanks

  2. #2
    Board Regular machopicho's Avatar
    Join Date
    Feb 2010
    Location
    Varese (Italy) Village: Lat. 45° 43' 48.36" N Long. 8° 48' 9.72" E
    Posts
    606
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hide Border of Currently Active Cell

    Regards
    Machopicho

    ---> All'apprendimento non si dedica MAI troppo tempo!!! <---

  3. #3
    New Member
    Join Date
    Apr 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Hide Border of Currently Active Cell

    This is the best answer:

    Code:
    Sub HideCursor()
       
        With ActiveSheet.UsedRange
            .Cells(.Rows.Count + 100, .Columns.Count + 100).Select
        End With
       
        ActiveWindow.ScrollIntoView 0, 0, 1, 1
       
    End Sub
    I have tested the above code in excel 2003 & 2010

    Source: Daily Dose of Excel » Blog Archive » Hiding the Cursor

Some videos you may like

User Tag List

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
  •