Machine checklist

Hello,

I'm trying to set-up a machine checklist.
But as this machine has a load of options on, I'd like to have the options selectable.
Problem with this is, some options go together and others change when they're selected together.

Please Login or Register  to view this content.

Weight cells- standalone
Cooling system- Temperature sensor- exhaust tube cooling- Hinged lid or sliding lid
Steam injection- temperature sensor- weight cells- hinged lid or sliding lid
Dosing unit- standalone
Vacuum unit- Exhaust valve vacuum- hinged lid or sliding lid

As for the above, that wasn't much of an issue.
These seem to be working, you can't select hinged lid and sliding lid at the same time.

The hard part (atleast, for me) starts when i'd like to combine Vacuum with the steam injection and cooling system.
This configuration would look something like this:
Vacuum unit- Steam injection- Cooling system- Exhaust tube cooling+vacuum- Hinged lid or sliding lid

Problem is, when i have "cooling system" selected with the "exhaust tube cooling" in the code I can't deselect the exhaust tube and select the "exhaust tube cooling+vacuum" instead, Same goes for the "Vacuum unit" and the "exhaust valve vacuum"


As a last question or sidenote, my "Select all" and Deselect all" buttons do not seem to be working at the moment.

Runtime error '1004': Unable to get the OLEObjects property of the worksheet class

Thank you for taking the time in reading this and hopefully help me out!

Rick

Just realised my request might not be too clear.
I'd like to try to get something like this in the workbook:
-IF checkbox 1 is selected, unhide sheet 3 and 4
-IF checkbox 2 is selected, unhide sheet 5 and 6
-IF checkboxes 1 and 2 are both selected, unhide sheet 7 and 8

Hope this will clear up the question a bit.

Rick

Ok, so after some proper thinking about the issue I came up with a new approach to the problem.
Only thing that goes wrong now is the Deselect all option.
That gives out the same error as before: Runtime error '1004': Unable to get the OLEObjects property of the worksheet class.

Please Login or Register  to view this content.

Have no idea what I'm doing wrong with CheckBox10...

Rick

Any ideas anyone?