Sorry I sounded close-minded in my asking for help. I am willing to use any advice and not suggesting a solution but trying to describe the task/problem.
To try and make things clearer, this is the code I use:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
If ActiveCell.Row > 16 Then
Dim myShape As Shape
Set myShape = Me.Shapes("Button 1")
With Me.Cells(1, ActiveWindow.ScrollColumn)
myShape.Top = 30 '.Top
myShape.Left = .Left
End With
End If
End Sub
It works great at keeping my button visible on the worksheet after it has been autofiltered. The problem is the code won't work if it is in a module. It has to be hard coded into the sheet itself. I have to open the visual basic editor and insert the code under VBAProject-Microsoft Excel Objects-Sheet1.
My question then is, how can I get a macro to insert the code at the Sheet level?
Thanks