Thread: Pivot table and Dsum security
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default Pivot table and Dsum security
It's not foolproof, but you can use worksheet protection, or programming
to lock parts of the pivot table. There's sample code he

http://www.contextures.com/xlPivot12.html

A cell with a DSUM formula can be locked, and the sheet protected.

Heather wrote:
Can someone tell if it is possible to secure a pivot table? (Aside from
locking down the cells.) If you also know how to secure the Dsum fuction
please let me know.

Thank you,

Heather


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote