Hello,
On a sheet (first_sheet), i have activex comboboxes on a grid that contains values of sheets/columns, so that for each sheet if YES is selected nothing happens, but when NO is selected, these columns must be removed automatically from these sheets right after their generation.
Now the logical order that the user should follow is:
1 - On the Sheet "first_sheet" the user should select whether or not certain columns are to be kept or removed on each of the defined sheets.
2 - Then on another sheet "macro_sheet", the user should click on the button that would create the sheets WITHOUT the columns.
Now the macro creating the sheets works, and i would like to add a script that removes those selected columns. Can someone help me resolve this?
Thanks in advance
On a sheet (first_sheet), i have activex comboboxes on a grid that contains values of sheets/columns, so that for each sheet if YES is selected nothing happens, but when NO is selected, these columns must be removed automatically from these sheets right after their generation.
Now the logical order that the user should follow is:
1 - On the Sheet "first_sheet" the user should select whether or not certain columns are to be kept or removed on each of the defined sheets.
2 - Then on another sheet "macro_sheet", the user should click on the button that would create the sheets WITHOUT the columns.
Now the macro creating the sheets works, and i would like to add a script that removes those selected columns. Can someone help me resolve this?
Thanks in advance
