Pivot Table

1. Disable menu

    'Disable show/hide Field list menu
    sht.PivotTables(1).EnableFieldList = False
    ''script to disable refresh menu 
    'sht.PivotTables(1).PivotCache.EnableRefresh = False

 

posted @ 2016-12-12 16:23  h.yl  阅读(124)  评论(0)  编辑  收藏  举报