Hi all,
I want to have a VBA Code how automaticaly hide columns.
There are two excelsheets: "Inleiding" and "Checklist Toelichting Algemeen".
There are three criteria in c8 of excelsheet "Inleiding": "Groot", "Middelgroot" and "Klein".
The VBA code need to do the following things:
- If cel c8 in excelsheet "Inleiding" give "Groot" then hide column D and E in excelsheet "Checklist Toelichting Algemeen".
- If cel c8 in excelsheet "Inleiding" give "Middelgroot" then hide column C and E in excelsheet "Checklist Toelichting Algemeen".
- If cel c8 in excelsheet "Inleiding" give "Klein" then hide column C and D in excelsheet "Checklist Toelichting Algemeen".
Thanks in advance.
Regards,
Aldwin
I want to have a VBA Code how automaticaly hide columns.
There are two excelsheets: "Inleiding" and "Checklist Toelichting Algemeen".
There are three criteria in c8 of excelsheet "Inleiding": "Groot", "Middelgroot" and "Klein".
The VBA code need to do the following things:
- If cel c8 in excelsheet "Inleiding" give "Groot" then hide column D and E in excelsheet "Checklist Toelichting Algemeen".
- If cel c8 in excelsheet "Inleiding" give "Middelgroot" then hide column C and E in excelsheet "Checklist Toelichting Algemeen".
- If cel c8 in excelsheet "Inleiding" give "Klein" then hide column C and D in excelsheet "Checklist Toelichting Algemeen".
Thanks in advance.
Regards,
Aldwin