Dynamically Highlight a Button on a Sheet for an Active Window

[#1]

I'm attempting to configure a Button on a Sheet, linked to another sheet, to highlight when a Window(i.e. Chart) is active on the specific sheet.  Does anyone know if this is possible?

[Gysbert_Wassenaar]

That's not possible.

[#3]

Thanks for the response.

[awhitfield · Accepted solution]

Hi Jeff,

looking around the community, the ability to an  action to a chart object, disappeared with the demise of V10

Andy

[Anonymous]

You can create a macro that checks if an object is active or not.  The problem is - the objects on "another sheet" are all inactive.  Just try to activate an object and switch between the sheets back and forth.

The best you can do is to define if the object "was" active before you move to a different sheet.

Here is an example of a macro (variable vCH01Active will be True or False):

sub test

set ch=ActiveDocument.GetSheetObject("CH01")

set v=ActiveDocument.GetVariable("vCH01Active")

v.SetContent ch.IsActive, true

end sub