Bravurian17
New Member
- Joined
- Apr 16, 2009
- Messages
- 34
I want to be able to keep that calendar directly under the freeze pane line when I scroll. I have used this code to do it (sort of).
Is there a way to do it without having to select a cell?
Thanks in advance!
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Calendar_A.Left = Cells(1, ActiveWindow.ScrollColumn).Left + 810
Calendar_A.Top = Cells(ActiveWindow.ScrollRow, 1).Top + 10
End Sub
Is there a way to do it without having to select a cell?
Thanks in advance!