Pivot Table drilldown and protecting workbook
 

I have an excel report with several sheets, each containing a pivot
table. The sheet that contains all the data from the database is
hidden and refreshed through code.

What I would LIKE to do is protect the sheets from being changed.
This is solved part way by protecting the sheets themselves, but users
can still accidentally delete a sheet. This is a major concern given
that the pivot tables have drilldowns that open up new sheets, so user
must delete these themselves.

My refresh of data and pivot tables works as follows:
- Refresh Data on my "Data" sheet (always left unprotected)
- For each worksheet,
- Unprotect sheet
- Iterate through each pivot table and refresh
- Protect sheet


Works great, but like I said, need that one step further to prevent
user from accidentally deleting sheets. How do I allow the user to do
drill downs in a pivot table, which creates a new sheet, allow users
to delete those newly created sheets, but prevent them from deleting
the "primary" sheets?


Thanks in advance,
Clayton

Pivot Table drilldown and protecting workbook
 

Anyone?

On Wed, 11 Apr 2007 19:05:47 -0700, Clayton Dool
wrote:

I have an excel report with several sheets, each containing a pivot
table. The sheet that contains all the data from the database is
hidden and refreshed through code.

What I would LIKE to do is protect the sheets from being changed.
This is solved part way by protecting the sheets themselves, but users
can still accidentally delete a sheet. This is a major concern given
that the pivot tables have drilldowns that open up new sheets, so user
must delete these themselves.

My refresh of data and pivot tables works as follows:
- Refresh Data on my "Data" sheet (always left unprotected)
- For each worksheet,
- Unprotect sheet
- Iterate through each pivot table and refresh
- Protect sheet


Works great, but like I said, need that one step further to prevent
user from accidentally deleting sheets. How do I allow the user to do
drill downs in a pivot table, which creates a new sheet, allow users
to delete those newly created sheets, but prevent them from deleting
the "primary" sheets?


Thanks in advance,
Clayton