Solved

Trap Excel 2007 Events in C#

Posted on 2011-03-02
2
536 Views
Last Modified: 2013-11-26
Hi

I have made a C# Excel 2007 Add-in, that shows some pivot charts.

On a Ribbon I have placed two buttons for toggling the Pivot Chart Filter Pane and the Pivot Table Field List.

I would like to simulate the functionality of the two Toggle Buttons found in Excel -> Analyze -> Show/Hide.

My problem is now how to get my two toggle buttons in sync with the panes.

I need to know how to get a handle to the Excel event for either the two original Toggle buttons or the event when the two panes are shown.

Br
Lars
0
Comment
Question by:liversen
  • 2
2 Comments
 
LVL 30

Expert Comment

by:MlandaT
ID: 35993352
One method I used to use to determine what a button does behind the scenes was to record a macro and then review the code for that macro and see what Excel was doing behind the scenes. might help you here. record a new macro, click the original toggle buttons then stop recording the macro and see what the code says.
0
 
LVL 30

Accepted Solution

by:
MlandaT earned 500 total points
ID: 35993371
When I try this... if I correctly understood the button you were refering to:
 Button you want.
And the generated code:
 generated macro codeAnd hence:
    ActiveWorkbook.ShowPivotTableFieldList = False
    ActiveWorkbook.ShowPivotTableFieldList = True

Open in new window

0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help with WinAPI Signatures in VB.NET for SetWindowSubclass 2 34
Excel import error " External table is not in expected format" 12 48
Problem to error 4 43
oracle 11g 23 46
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand columnThat will then direct you to their download page.From that page s…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now