Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator

How can I identify if a chart is hidden ffrom within vba macro?

I have a macro which works on several charts. However, some of the charts are sometimes hidden. The macro hangs when it references a hidden chart.

1 Solution

Accepted Solutions
gf
Creator III
Creator III

Save the chart visibility status in a variable.
Set the variable "1" if visible and "0" if not visible.
Then in your macro check the number first.

View solution in original post

1 Reply
gf
Creator III
Creator III

Save the chart visibility status in a variable.
Set the variable "1" if visible and "0" if not visible.
Then in your macro check the number first.