Visible/Invisible Several Button, 3 Criteria

Hello blues_oo7,

This proved to be an interesting challenge. It seemed straightforward in the beginning but took some unexpected turns. User Defined Functions are tricky. When run in VB environment there are no restrictions. However, when used on a worksheet, things get interesting.

To make this hide an unhide the button, the UDF have to be made volatile. Rather than executing when needed, it is executed every time a formula on the worksheet is recalculated. This can slow you down.

The UDF takes four arguments: The Button Index Number, the column "F" cell, the column "D" cell, and $G$2. The UDF returns either TRUE or a Blank. The UDF formula is behind each button.

Here is the UDF code:

Please Login or Register  to view this content.

Hello blues_oo7,

What other buttons? I only saw "PAID" buttons on the worksheet.

I think this one-liner suffices:

Please Login or Register  to view this content.