Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Name of Event for Sheet

I'm attempting to write code that hides the PivotTable
Field List when a Pivot Table is either created or
updated, but I haven't found an event that will trigger
the code. What I have written will hide the list when a
new sheet is created, but doesn't do anything when you
create or modify the table on a current sheet. Can anyone
help me find an event to trigger this code?

This is what I have in a Class Module:

Private Sub App_SheetActivate(ByVal Sh As Object)
'Don't show Pivot Table Field List when creating a Pivot
Table

Dim wkbOne As Workbook

Set wkbOne = Application.ActiveWorkbook

'Determine PivotTable field list setting.
If wkbOne.ShowPivotTableFieldList = True Then
wkbOne.ShowPivotTableFieldList = False
End If

End Sub
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sheet event doesn't work in '97 Gareth[_3_] Excel Programming 14 November 2nd 03 11:36 PM
Sheet Event Gareth[_3_] Excel Programming 2 November 1st 03 03:29 PM
Sheet Event? Gareth[_3_] Excel Programming 3 October 18th 03 12:48 AM
Sheet Name Change Event? Bob L. Excel Programming 0 August 18th 03 10:08 PM
Sheet Name Change Event? Bob Phillips[_5_] Excel Programming 0 August 18th 03 09:57 PM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"