Protect and unprotect Pivot table

V

VJ

Hi,

Is there any way we can protect and unprotect the pivot table only through
macro not the whole sheet?

Thanks
 
F

Frank Kabel

Hi
you can only protect the whole sheet BUT you can try the following:
- select the other cells
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- NOW protect your worksheet
 
T

Tom Ogilvy

Use the
Activesheet.EnablePivotTable
Activesheet.Protect Password:="ABC", UserInterfaceOnly:=True

This must be done each time the workbook is opened as the EnablePivotTable
and UserInterfaceOnly settings are not persistent across the closing of a
workbook (so use the workbook open event as an example. )
 
Top