Hi,

One of the sheets of a workbook has a pivot table. All works fine till
the workbook is protected. When the workbook is protected and opened:
a message box appears with the following log:

Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\rsp\excel\1testprotection cee.xls'
The following is a list of repairs:
PivotTable report 'PT2' on '[1testprotection cee.xls]Summary' was
discarded due to integrity problems.

The workbook.open event has the Workbook.unprotect code at the
beginning and workbook.protect code at the end. I did this as the
workbook.open event was failing at the following line:
Worksheets("Change log").Visible = False
(I wanted to hide this sheet on opening the workbook)

Thanks in advance for the help.

Regards,
Raj