in the picture it has copied over the colour of the cells also? but when i compile it does not just the text and text colour any reason for this? ( this is not an issue but im curious)
I don't know. It may have to do with the following code that is not supported in Excel 2003:
See what happens when you comment out the above code.
how do i now edit size of the check boxes?
Unfortunately, the size of the text boxes is fixed by Excel and can't be changed. I will try to post an update in a couple of days, with a different type of control that has the look and feel of a CheckBox, but can have it's size customized.
if i so wished or add another for say sheet 8 if i created a sheet 8 ( Section 8)
Changes have to be made in two places:
In ModUtilities, the following number has to be changed:
In ModUtilities, the following number may have to be changed for PrettyPrint spacing purposes:
In Module1, the following number has to be changed.
Bookmarks