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

Thread: Hide Border of Currently Active Cell

  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
  •