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

selecting workbook/sheet 3
Open file with a Pivottable Protected 0
Enabling Macros message when NO macros in workbook 3
Solved Disk Full error message when exporting PDF 0
Pivot Table Refresh option not able to see 1
Refresh order when refreshing all in a workbook 1
Please help! Cannot open pivotTable source file.... 2
Auto insert of a pivot table? 1

Top