![]() Print Preview in Excel, any other program, other Excel files will return the problem sheet back to original layout on return. ![]() You can get the movement to return to original state by doing almost any new view and return. When the movement of theīoxes is noticed, if you change the current sheet you are on and then come back to the problem sheet, the boxes will have shifted back to their original location. Movement shifts to the left 2-3 columns from original set point. The 2010 program will pick all of them up and shift there placement on sheet. These files were in use for several years under the 97-2003 version without issue. ![]() Nothing unusual, and all of the controls are property set to "Dont move or size with cells". The files have manyįorm Control- Combo List Boxes and Check Boxes for users to choose response from, a cell is linked to each box response. I cannot recreate the issue on demand, it happens at what seems to be random moments. Running 2010 program, not sure what you mean by "build", but all of the files in use having this difficulty, are converted to 2010 from 97-2003 Excel. You can try right clicking on the form control and choose Format Control | Properties | "Don't move or size with cells" Describe the behavior you are seeing and simple steps to reproduce what you are seeing. Need some more details from you regarding this:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |