topic Changing Sheet Properties via vbMacro [Security] in QlikView

Changing Sheet Properties via vbMacro [Security]

Tue, 29 Nov 2011 17:01:19 GMT

Hi everyone

I need to change via VBMacro the settings of my Qvw before publishing on the server

It's a common operation i do every time i modify my presentation, just before the publication.

I need a fast code to switch from this situation

to this

anybody can help me?

fosuzuki — Tue, 29 Nov 2011 18:43:07 GMT

Hi Lucky,

have you ever used the ApiGuide.qvw? There are a lot of useful information there, regarding on how to use the Automation API.

To configure the sheet permissions, you must use something like:

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.UserPermissions.AddSheetObject = false

mysheet.SetProperties sp

Check the class ISheetPermissions in the ApiGuide, to see how to set each Security parameter.

Hope this helps you.

Regards,

Fernando

Thu, 01 Dec 2011 09:13:27 GMT

Thankyou so much Fernando

Your answer was so useful, I often use the ApiGuide.qvw

But in this case i cannot find the security Parameters to be set

fosuzuki — Thu, 01 Dec 2011 09:24:37 GMT

hi Luky,

if you only select 'ISheetPermissions' in the Class field, you will get something like this:

And so in the Member field you can find all the options that exist in the Security tab.

Regards,

Fernando

Thu, 01 Dec 2011 10:45:45 GMT

Thankyou Fernando, all ok

I'm only trying to write the Vbmacro that involves the full collection of Sheets of the project...