Solved: Fix the Controls

[Tommy]

I have this workbook that is driving me Daisy.
I can fix the captions by code, I can delete them with code.

What I can't seem to do is fix it without writting code. I like writting code. I prefer to write code. I don't like writting code that will be used once and thown away never to be used again. Besides that I think there is another way. SO my question.

1) How do I change the controls that are imbedded into the sample worksheet posted?
2)Is there a function that counts the number of worksheets?

Thanks so much for your time in advance.

[Bob Phillips]

They are ActiveX controls, so just go into desgn mode, click the Design Mode icon on th Controls Toolbox.

[Kenneth Hobs]

To fix the captions, click the Design icon on the Control Toolbox toolbar. Right click object and Checkbox Object > Edit.

For the sheet count, add a named range called wsCount and set the Refers =Get.Workbook(4). Then in a cell, =wsCount+0*Now(). When the next calculation occurs, the cell will update.

[Tommy]

OK I got it already.

Boy howdy, that was just to simple, I will have to think of more difficult ones. Well I guess that will have to wait until I can figure out the easy ones. LOL