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. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    232
    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
  •