Hi riedyp,
What you are seeing is a symptom typical of 'Active X' controls in Excel Worksheets. Welcome to the wacky world of Excel vs. ActiveX.My difficulty is having the activex checkboxes dissappear and reappear with their intended rows.
There is no easy solution to your problem, as all solutions require a good deal of work. Solutions include:
a. Deleting all 'Active X' when you open the Workbook, and recreate the 'Active X' using VBA.
b. Using Forms Controls instead of 'Active X' controls.
c. Using a UserForm instead of 'Active X' controls.
d. Create Pseudo CheckBoxes using Shapes.
e. Use Cells as CheckBoxes using 'Marlett Font'. See http://www.excelforum.com/excel-gene...ml#post4192981
Good luck.
Lewis
Bookmarks