Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect and unprotect Pivot table
Hi,
Is there any way we can protect and unprotect the pivot table only through macro not the whole sheet? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect and unprotect Pivot table
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 -- Regards Frank Kabel Frankfurt, Germany VJ wrote: Hi, Is there any way we can protect and unprotect the pivot table only through macro not the whole sheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect field on Pivot Table | Excel Discussion (Misc queries) | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
PROTECT PIVOT TABLE | Excel Discussion (Misc queries) | |||
Pivot table with protect workbook | Excel Discussion (Misc queries) | |||
Unprotect and protect.... | Excel Programming |