Properties of a Hidden Sheet

[michaelfreitas]

How to get the properties of a hidden sheet? Using VBS.

Urgently needed, help please.

Thanks

[#2]

You should be able to reference the hidden sheet using the sheet's sheet ID.

[michaelfreitas]

Thanks for responding!
I've tried several ways and can not, if the tab is hidden with conditional.

set Result = ActiveDocument.GetSheetById("SH04").GetProperties

set Result = ActiveDocument.Sheets(SH04).GetProperties

Thanks

[Sokkorn]

Hi,

Try to check QV API in your local installation C:\Program Files (x86)\QlikView\Documentation\APIguide.qvw

Let me know if this one help you.

Regards,

Sokkorn

[#5]

Hi,

I dont think we any such option to access hidden sheet.

But i think you know that to access that hidden sheet manually, you should go to Settings -> Document Properties -> Sheets tab.

Cheers.

[michaelfreitas]

Thank you, Cheers and Sokkorn.
I do use the API GUIDE long ago, and has developed many scripts from it.
We also know the tool options.
But one of the few things I could not do today is get the settings from a hidden sheet via macro.
If any of you, friends, know I'll be very grateful, because I've tried everything.

[#7]

Sorry it has taken me so long to respond again, I was out of my office yesterday.  I did alittle bit of research for you, and everything that I have seen shows that you are not able to reference a hidden sheet to get the properties.  I am wondering though if it is possible to unhide the sheet temporarily get the properties and then rehide it.  If you want to try this, I will as well, and Ill let you know.

Regards,
Jeff

[michaelfreitas]

Thank you Jeff for concern, help me.

I discovered a light at the end of the tunnel.

Shortcut keys ctrl + shift + s
http://community.qlik.com/message/31300#31300

They display all the sheets and pressing them again appear.

Helps, as I activate the shortcut, run the macro again and off using the shortcut.

Regardless of the sheets possess conditional, the shortcut displays them.

As I understand conditionals are only disabled and enabled again.

I would also like to know the original question. But this time, the solution of the shortcut helps.

Original question: How to get the properties of a hidden sheet? Using VBS.
New question: Simulate Ctrl + shift + s, using VBS.

Thanks Jeff and other friends

[#9]

Hey Michael,

I had just thought of something.  If you have the sheets hidden based off a variable, say the variable  = 1.  Then have it so the sheet is not hidden if the variable is equal to 1.  Now change the value of the variable to 2 and it will be hidden.  In your macro you could unhide the sheet with the variable, get the properties and then rehide it.  I did find a method in VBS that contains sending the automation of the key strokes. .SendKeys "^+s"    i believe that is what it would look like.  It is a function of an object.  Just for reference the ^ = Ctrl, + = Shift, and then s.   Hope this helps!

Regards,

Jeff

[michaelfreitas]

Very interesting SendKeys function, but found nothing in APIGuide or on the web. Nothing works.
QlikView is found where the option simulated this shortcut:
Document Settings .. Properties .. .. Security Option Show all folders and objects.

And through this macro should change the value. But do not get run.

temp = ActiveDocument.GetProperties.UserPermissions.ShowAllSheetsAndObjects
if temp then msgbox ("Show on condition ADMIN override")
temp = ActiveDocument.GetProperties
temp.UserPermissions.ShowAllSheetsAndObjects = false
ActiveDocument.SetProperties temp

If you can run the macro, and/or SenKeys, I'll be grateful.