Error Message when I open Workbook

M

Mouimet

I have a Workbook with many sheets. I create 5 Pivot Table for different
reports.
All sheets are protected and the user click on buttons to refresh the Pivot
table.
No problem there.

The problem occur each time I open the Workbook and I see this message:
"That command cannot be performed while protected sheet contains another
PivotTable report bases on the same source Data."
How can I bypass this message?
Thanks
 
M

Mouimet

Hi
Sorry,this is not what I need
I do not want to unprotect the sheets.
The sheets need to be protected all time. This is why I add a button
"REFRESH" in each Pivot table. I do not want the user to work on a unprotect
sheet.
What I need is how to bypass the error message when we open the Workbook.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Refresh option not able to see 1
custom views in protected worksheets 1
Refresh order when refreshing all in a workbook 1
Auto insert of a pivot table? 1
Pivot Table Macro 1
Workbook pivot table design function 6
Pivot Table - Old remaining values for rows 3
Refresh pivot table in workbook A when changing a cell in workbook 2

Top