The mystery of the moving controls

[wpryan]

This is a strange one... One of my worksheets has two control buttons whose properties are set to "don't move or size with cells" and two option buttons whose properties are set to "move but don't size with cells". Occasionally I"ll open the workbook and these items will have mysteriously moved to other parts of the worksheet. Unfortunately they move to a part of the worksheet where data entry is expected, obscuring the data entry fields. The sheet is locked, so there is nothing going on that should cause this. All controls are Form controls (not ActiveX). Any ideas?

This was originally posted here, but I didn't have any luck: http://www.mrexcel.com/forum/excel-q...-controls.html

[Kyle123]

Could you attach a workbook?

[wpryan]

Attached. All worksheets are locked, macro to unlock ctrl+u, lock it back up ctrl+l (as in lock). The phenomenon seems to be pretty random...