Hide Button VBA if cells contain value

BCUHB

New Member
Joined
Oct 13, 2017
Messages
1
Hi all, I would like some help with the following macro.
I have an excel worksheet that the user can fill cells:

C13:D18

The data from each row of cells, i.e. C13&D13, C14&D14 etc. is then used to fill in hidden sheets. See below for an example:

First hidden sheet fills in a template with the data from C13&D13
Second hidden sheet fills in a template with the data from C13&D13 and C14&D14.
Third hidden sheet fills in a template with the data from C13&D13, C14&D14 and C15&D15
Fourth sheet etc.

I have wrote the macro that allows the user to print the hidden sheet and that hides the sheet after printing.

However, I am seeking help in writing a macro that will hide the “print” button that refers to the first hidden sheet when the second row of data is filled in (i.e. when rows C13:D14 are completed, I only want the button for ‘Print 2 rows’ to be displayed).
Similarly when cells C13:D15 are filled in, I only want the button for 'Print 3 rows' to be displayed. etc.

Is it possible to have a macro that hides a button? I have created the button using the insert shape option.

Thanks for all the help.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,216,112
Messages
6,128,901
Members
449,477
Latest member
panjongshing

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top