No one answered previously so i will ask again.

If the window is split rather than freeze panes, in vba the
ActiveCell.Address is misdetected as A1.

Shall I just turn of the user's abiility to split a window in the
workbook? or is there a workaround?

Thanks
Scott