Matt Burns
New Member
Hello Chandoo Community,
I've found a few threads related to hiding/revealing control buttons based on a cell's value but have thus far been unable to translate that information into what I need my Excel sheet to do.
My objective is to have one of two sets of control buttons appear given the combination of inputs in two separate cells.
There are three conditions:
1. The sales price is greater than zero and the system type chosen is "S".
2. The sales price is greater than zero and the system type chosen is "F".
3. Neither condition 1 or 2 is met.
If condition 1 is met, three control buttons appear: a button that opens up a new PO form tab in the workbook, a button that opens up a new spec sheet tab for "S" systems in the workbook, and a button that runs a print screen macro for that "S" system spec.
If condition 2 is met, three control buttons appear: the same PO button again, and two buttons for the "F" systems.
If neither condition is met then all buttons remain hidden.
My sample sheet is attached.
The two variables are the dollar amount appearing in cell C2 and the selection chosen in cell C3.
I appreciate any input.
Thank you.
~MB
I've found a few threads related to hiding/revealing control buttons based on a cell's value but have thus far been unable to translate that information into what I need my Excel sheet to do.
My objective is to have one of two sets of control buttons appear given the combination of inputs in two separate cells.
There are three conditions:
1. The sales price is greater than zero and the system type chosen is "S".
2. The sales price is greater than zero and the system type chosen is "F".
3. Neither condition 1 or 2 is met.
If condition 1 is met, three control buttons appear: a button that opens up a new PO form tab in the workbook, a button that opens up a new spec sheet tab for "S" systems in the workbook, and a button that runs a print screen macro for that "S" system spec.
If condition 2 is met, three control buttons appear: the same PO button again, and two buttons for the "F" systems.
If neither condition is met then all buttons remain hidden.
My sample sheet is attached.
The two variables are the dollar amount appearing in cell C2 and the selection chosen in cell C3.
I appreciate any input.
Thank you.
~MB
Last edited:
