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.
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.