2013-12-19, 07:11 #1
- Join Date
- May 2003
- Thanked 0 Times in 0 Posts
Excel 2010 - check boxes and option buttons move after save and re-open
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?
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!
+ 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!
2013-12-19, 13:55 #2
- Join Date
- Nov 2002
- New York, New York, USA
- Thanked 11 Times in 11 Posts
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,