Hello,
I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do one side or the other for this problem, but have had no success combining the two.
The book has 13 sheets total which need to remain, 5 of which are hidden. There are 4 different PivotTables on two sheets.
Thank you,
Kaylan
I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do one side or the other for this problem, but have had no success combining the two.
The book has 13 sheets total which need to remain, 5 of which are hidden. There are 4 different PivotTables on two sheets.
Thank you,
Kaylan