Run macro upon selection of a chart sheet

mcbien

New Member
Joined
Sep 17, 2014
Messages
5
Hello. I am trying to run a macro upon the selection of a chart sheet. I can successfully run a macro upon selection of a worksheet by putting the following code on the worksheet module:

Private Sub Worksheet_Activate()
MsgBox "WARNING: To paste your data, please use the PASTE MY DATA BUTTON on row 9. DO NOT use any other method of pasting your data. Please press Ok."
End Sub

However, when I try to do the same with a Chart Sheet (sheet with embedded pivot chart), the code does not work. I believe this is because a sheet with an embedded chart.

I tried to put the following code in the Sheet code of the chart worksheet:

Private Sub Sheet_Activate()
ActiveChart.DeSelect
End Sub

I need to be able to deselect the active chart when the chart sheet is selected.

Any idea? Thanks in advance!!

mcbien
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

Code:
Private Sub Chart_Activate()
'your code here
End Sub
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,827
Messages
5,855,878
Members
431,771
Latest member
CoryMelth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top