Thank you for your response.
I am developing an Qlikview Application and I want the information about all the sheets and objects that are hidden or not.
Is there a way to achieve this ?
Problem arises in using Objects = ss.GetSheetObjects and when I try to extract information from different objects on the sheet i.e copy bitmap to clipboard etc. In the case of the hidden objects it constantly copies the last unhidden objects image to clipboard.
Lokesh, I'm still not quite sure what you're trying to achieve.
What kind of information about the sheets and objects are your after? Number of objects? Object IDs? Exporting of multiple objects?
The Expression Overview would be a good place to start as it will give you a full list of objects which contains an expression, hidden or not.
Otherwise, I think Rob W. has a document analyzer app available for download.
Instead of going for a macro you can show/hide a sheet or object using a variable and buttons
Create a variable using Settings Menu -> Variable Overview and create a variable
Sheet Properties -> Show Sheet -> Select Conditional and give =vShow
Object Properties -> Layout -> Show -> Conditional -> and give =vShow
Now Create button and
Button Properties -> General -> Text -> Give If(vShow = 1, 'Hide', 'Show') ->
Actions -> Add-> External -> Set Variable -> Variable = vShow
Value = =If(vShow =1, 0, 1)
Hope this helps you.