Mattex, You certainly can do it by using a macro. But first you need a variable that you'll be using in "show condition". So, 1. Create a variable, let call it vShow. 2. In your list box, use show condition =vShow. 3. Macro:
sub Show set v=ActiveDocument.Variables("vShow") set ch=ActiveDocument.GetSheetObject("CH01") if ch.IsMinimized then v.SetContent 0, true else SetContent 1, true end if end sub
4. Now, you have to decide what event is good to trigger the macro. It may be assigned, for example, to "Activate chart CH01". But it is just my assumption, it can be right or wrong in your specific situation. Besides, keep in mind that the macro should be triggered also by the events that you want to show the list box again.
