I am not well skilled in VBA so looking for assistance.
I have 2 similar situations:
1.
I have a pivot table that for columns headers are displayed as weeks. IE Week 01 Week 02 Week 03
Needless to say if data hasn't been entered into the source data for Week 04, there is no Week 04 in the pivot table.
Looking for some VBA that will automatically hide all the columns without a Week. I can not base this on values inside the pivot table itself as there may be no data to pivot, but I still have a Week and need to display it.
2. Similar to 1 except this is a PW protected sheet I set up for the owners with direct references to cells in item 1. Needless to say, in the above scenario for Week 04, the owners sheet displays a 0.
Also I would like to embed this in a way that it controls multiple worksheets, but not all. Some of the workbooks have 30+ worksheets in them. There may not be a way to do that without it impacting the entire workbook, so if I need to add the VBA to the desired sheets, so be it.
Thank you
Mark
I have 2 similar situations:
1.
I have a pivot table that for columns headers are displayed as weeks. IE Week 01 Week 02 Week 03
Needless to say if data hasn't been entered into the source data for Week 04, there is no Week 04 in the pivot table.
Looking for some VBA that will automatically hide all the columns without a Week. I can not base this on values inside the pivot table itself as there may be no data to pivot, but I still have a Week and need to display it.
2. Similar to 1 except this is a PW protected sheet I set up for the owners with direct references to cells in item 1. Needless to say, in the above scenario for Week 04, the owners sheet displays a 0.
Also I would like to embed this in a way that it controls multiple worksheets, but not all. Some of the workbooks have 30+ worksheets in them. There may not be a way to do that without it impacting the entire workbook, so if I need to add the VBA to the desired sheets, so be it.
Thank you
Mark
