Green Cell Selection Marker

[Guzzlr]

Hello All,
Here's a trivial question, but it bothers me.
I always end my program with Selecting A1. However, the green cell select marker remains.

How can I hide the green cell marker, at the very end of the code, until a user clicks on another cell, and the cell marker reappears as normal?
Thanks
excel 2010

 

[My Aswer Is This]

Please explain what a:
"the green cell select marker remains"

Is?

I don't understand: "the green cell select marker remains"

Do you mean the selection area?

If you want no cell selected then that's not possible.
Unless we select "A1" then scroll down 45 rows so you will not see Range("A1")

Something like this:

Sub Scroll_Down()
Range("A1").Select
ActiveWindow.ScrollRow = 45
End Sub

 

[Guzzlr]

'Select A1 on All work Sheets & Return to Template Tab
For Each sht In ActiveWorkbook.Worksheets
    If sht.Visible Then
        sht.Activate
        Range("A1").Select
    End If
Next sht
Sheets("Template").Select
Rows("1:1").Clear
Range("A1") = "v2.1"
ActiveWindow.ScrollRow = 100
Columns("A:B").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
    End With

End Sub

Here is my code at the end of the program. Although your code does get rid of the green boarder surrounding A1, it also leaves A1 out of sight and my code to select columns A:B becomes Grayed Out and surrounded by the green boarder.
With your code, can we scroll back up and running my A:B column select, and we scroll back up to the top, with no gray cells or cells selected, effectively getting rid of the green cell select boarder?
Thanks for the help

 

[My Aswer Is This]

Well my little suggestion does not get rid of the Green Boarder. It's just that you cannot now see the active cell. Not sure what your trying to do. I just gave you a suggestion. I have never had a person who want's to select a cell but does not want to see the cell selected.

'Select A1 on All work Sheets & Return to Template Tab
For Each sht In ActiveWorkbook.Worksheets
    If sht.Visible Then
        sht.Activate
        Range("A1").Select
    End If
Next sht
Sheets("Template").Select
Rows("1:1").Clear
Range("A1") = "v2.1"
ActiveWindow.ScrollRow = 100
Columns("A:B").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
    End With

End Sub

Here is my code at the end of the program. Although your code does get rid of the green boarder surrounding A1, it also leaves A1 out of sight and my code to select columns A:B becomes Grayed Out and surrounded by the green boarder.
With your code, can we scroll back up and running my A:B column select, and we scroll back up to the top, with no gray cells or cells selected, effectively getting rid of the green cell select boarder?
Thanks for the help