Thank you very much! Having to change the PW only once would be very useful, as well as being able to add and delete rows without reworking all the code. I appreciate the Declare Variables tip.
So, do I need to link the check box with the E cell on the specified line, or just place it there? Last time I tried to link an active-X checkbox it hung up indefinately. Not sure if it was something I did or if linking Active-X checkboxes is just a no-no.
Also, there are actually 58 checkboxes ( I shortened the file so that it was more manageable for testing). For the section of code at the bottom, do I need to repeat that part for each checkbox 1-58? I noticed you included check box 1, 2 and 6...
Bookmarks