Worksheet_activate() does NOTHING in a CHARTSHEET?

Question

Worksheet_activate works great in any WORKSHEET, but if you put the same exact code in a CHARTSHEET, then it fails to do anything.

Try this in a WORKSHEET (works great!):

Private Sub Worksheet_Activate()

    MsgBox "Is Active"

End Sub

But add it (or anything similar) to a CHARTSHEET and it does absoltuely nothing...at all.

Bug?

Answer 1

You have to use Chart_Activate(), even if it is on its own sheet (which is not a "worksheet" even though it adds another sheet tab).

I got confused by this:

http://msdn.microsoft.com/en-us/library/office/ff198220%28v=office.15%29.aspx

...and the statement that it "Occurs when a workbook, worksheet, chart sheet, or embedded chart is activated.." (emphasis added)

The above references Worksheet.Activate (DOT and not an UNDERSCORE) and am not sure what the difference is (aside from it is for Office 2010 or 2013, but VBA scripts are the same in 2011 - maybe it's VB vs. VBA or such?), but so be it...

Sorry for the distraction!

Answer 2

Hi There,

Thanks for the update.

Do get back in case if you need further assistance.

Thank you