Hello,
I have a requirement to create a pivot table in excel if user selects 'Yes' in a drop down which is in cell C2.
I have a macro 'Pivot' which creates pivot table. I am looking for an option to disable the macro by default and if the value in drop down is 'No'. The 'Pivot' macro should be enabled only when the user selects 'Yes' in the drop down.
I have a requirement to create a pivot table in excel if user selects 'Yes' in a drop down which is in cell C2.
I have a macro 'Pivot' which creates pivot table. I am looking for an option to disable the macro by default and if the value in drop down is 'No'. The 'Pivot' macro should be enabled only when the user selects 'Yes' in the drop down.