K
Keith G Hicks
This works in a macro inside Excel
Range("G2").Select
ActiveWindow.FreezePanes = True
It does exactly what I'd expect. It puts a horizontal freeze line between
row 1 and row 2 and a vertical freeze line between column F and column G.
But I need to use from MS Access vba code so I'm doing this:
objExcelSht.Range("G2").Select
objExcelApp.ActiveWindow.FreezePanes = True
It does freeze but not the same way. It only puts in a vertical freeze line
between columns F and G. There is no horizontal freeze line.
What do I hvae to do from vba in Access to get the same results?
Thanks,
Keith
Range("G2").Select
ActiveWindow.FreezePanes = True
It does exactly what I'd expect. It puts a horizontal freeze line between
row 1 and row 2 and a vertical freeze line between column F and column G.
But I need to use from MS Access vba code so I'm doing this:
objExcelSht.Range("G2").Select
objExcelApp.ActiveWindow.FreezePanes = True
It does freeze but not the same way. It only puts in a vertical freeze line
between columns F and G. There is no horizontal freeze line.
What do I hvae to do from vba in Access to get the same results?
Thanks,
Keith