Checkboxes keep moving

Question

Hello,

I have an excel workbook that has check boxes in it. Sometimes when I save and close it and then open it later, the checkboxes have all shifted. I have looked on other forums for answers and people say to check the "dont move or size with cells" box but this is already checked on my workbook.

Other people are having the same issues with this workbook. I am using Windows XP and they are using Windows 8 with Office 2010. Another person is using Office 2007 and has the same issues with this workbook.

First screenshot it how it is supposed to look. Second screenshot shows the checkboxes moving after document is saved, closed, and then reopened. Third screenshot shows the properies of the checkbox.

Any help would be appreciated. I did have to blank out sensitive information on the screenshots. Thanks.

Answer 1

Hello Melody,

This is a problem that has been around for some time. It appears to mostly occur when zooming has been applied to the worksheet. (ie. not 100%)

The only fix I am aware of is to use VBA code to re-position each time the workbook is opened. However, this means that I would need all of the checkbox names and the position where they are on the worksheet when correctly positioned.

Do you have any VBA code associated with the checkboxes or are they just marks used on the worksheet.

Would it be too difficult to use "Save As" to a new name to create a copy of the workbook and then delete all of the sensitive data from the copy so you can post a copy on OneDrive. If you can do this then I can code the repositioning and provide instructions on how to install the code into your production workbook (so you won't have to re-enter your data in the production workbook.) If you can do this then the following instructions to post a copy on OneDrive.

1.Zip your workbooks. I prefer that you don't not just save to OneDrive. (To Zip file, in Windows Explorer  Right click the on the selected file and select Send to -> Compressed (zipped) folder.)

2.Go to this link.  https://onedrive.live.com

3.Use the same login Id and Password that you use for this forum.

4.Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded and select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)

5.Right click the file on OneDrive and select Share.

6.Do NOT fill in the form; "Select Get a Link" on the left side.

7.Click the button "Create a Link"

8.Click in the box where the link is created and it will highlight.

9.Copy the link and paste into your reply on this forum.

Answer 2

Hello again Melody,

I have had a further think about this and I have come up with an idea that I have tested whereby I can write code that will loop through the checkboxes and save their name, size and location parameters to a hidden worksheet without needing a copy of the workbook.

However, assuming that you want to use the VBA solution, can you tell me what sort of checkboxes you used. Are they Forms control checkboxes or ActiveX control checkboxes? (Forms control checkboxes are created from the top of the dropdown when you select Insert in the Controls block and ActiveX are from the bottom half of the dropdown).

Answer 3

Hi OssieMac,

Thanks for the reply. Here is a link to my zipped file. I am not sure how the checkboxes were made. The creator thinks he used ActiveX but isn't sure.

https://onedrive.live.com/redir?resid=60157BD8643EA4A5!4132&authkey=!AEaZjaLeD6m1ezs&ithint=file%2c.zip