Make a Floating Calendar

[Bravurian17]

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).

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!

 

[Makrini]

Not sure exactly how your calendar works... but with any normal userform you could set the "showmodal" value to false

that way excel would kind of run "under" it.

 

[Bravurian17]

Thank you Makrini, that idea gave me exactly what I needed, with some tweeking of course.

Again thanks