I have a macro that gathers data and creates a scatter plot and that is saved to a new workbook. Each individual point in the plot has a label (DataLabel). Some of the points are so close together that the the labels are not visible. The user just simply moves the labels around with their mouse.
The macro also changes a few things in the PageSetup for the worksheet: Orientation to Landscape, a centered header, a right footer, etc.
When the user moves around the labels all of those PageSetup properties are wiped. The orientation is changed to Portrait and the headers and footers vanish.
Can I prevent this from happening?
(Office 2007)