Microsoft KB Archive/32132

{| = Excel: Cannot Move Auto-Positioned Objects in Dialog Editor =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q32132

SUMMARY
The Microsoft Excel Dialog Editor will not allow objects whose position has been set to Auto in the object information box to be dragged to a new position. To turn off Auto positioning, do the following:


 * 1) Open the object information box by either double-clicking the object or by clicking the object once and choosing Info from the Edit menu.
 * 2) Deselect Auto for the X and Y coordinates. The Dialog Editor will substitute the current X and Y coordinates.
 * 3) Click OK.

MORE INFORMATION
If a dialog box definition table has been copied from Excel and pasted into the Dialog Editor, any object whose X and Y position (columns 2 and 3) is left blank will be brought into the editor with its position set to Auto.

An object whose X position is set to Auto can still be moved vertically as long as its Y position is not set to Auto. Likewise, an object whose Y position is set to Auto can be moved horizontally as long as its X position is not set to Auto.
 * }