Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel 2010 - check boxes and option buttons move after save and re-open

    Please help...

    Using Excel 2010, I created a spreadsheet that includes check boxes and option buttons. When I save the document, everything looks fine, but when I re-open the document later, all the objects move to the upper left corner of the page.

    How can I get these objects to stop moving?

    Thank you!!!
    -Troy

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    228
    Thanks
    0
    Thanked 11 Times in 11 Posts
    Dear TMG9671

    If this workbook was created in an older version of Excel make sure you have converted it to an Excel 2010 xlsx or xlsm workbook.

    In addition, make sure the properties on the check boxes and option buttons are set to "Do Not Move or Size with Cells"

    The above should eliminate the problem. If not you may need to post the workbook so everyone in the Lounge can see the issue and hopefully find a work around.

    Hope this helps,

    Tom

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •