PDA

View Full Version : Solved: Fix the Controls



Tommy
10-08-2008, 01:35 PM
I have this workbook that is driving me Daisy. :banghead:
I can fix the captions by code, I can delete them with code.:thumb

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.:yes 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. :clap:

Bob Phillips
10-08-2008, 02:14 PM
They are ActiveX controls, so just go into desgn mode, click the Design Mode icon on th Controls Toolbox.

Kenneth Hobs
10-08-2008, 02:15 PM
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
10-08-2008, 02:43 PM
:bug: OK I got it already. :rofl:

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