×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Mysteriously Moving Controls

Mysteriously Moving Controls

Mysteriously Moving Controls

(OP)
A couple of us are co-creating a form in Excel with check boxes, drop downs, etc.  What little functionality we have we wanted to keep simple by triggering macros off of the controls rather than writing code, therefore we initially decided to use control objects rather than form objects.

What's happening is after I print or do a print preview, all of the control objects jumble up on the left side of the sheet.  This is not happening with anyone else who has worked with the file.

Anybody ever seen or heard of this?  Is it a bug or some mysterious setting?  Reinstalling Excel is probably the fix, but I just have to deal with the hassel of going thru IT.  

RE: Mysteriously Moving Controls

This is a bug recognized by Microsoft for Excel 2002 sp3 and later.  

see http://support.microsoft.com/default.aspx?kbid=838910

Their work-around is:

Quote:


WORKAROUND
To work around this problem, configure the positioning properties of the command button to the Move and size with cells option. To do this, follow these steps:
1. Right-click the command button, and then click Format Control.
2. On the Properties tab, click Move and size with cells.
3. Click OK.
By default, this option is set to the Move but don't size with cells option.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources