topic Macro for autominimising the objects in current active sheet..(Please post comments in any, for my further improvement) in QlikView

Macro for autominimising the objects in current active sheet..(Please post comments in any, for my further improvement)

Thu, 13 May 2010 14:54:49 GMT

sub

mat

'Rem minimize all active sheet objects on active sheet

set

s=ActiveDocument.ActiveSheet

for

i=lbound(objs) to ubound

(objs)

msgbox

(objs(i).GetCaption.Name.v)

end

sub

spsrk_84 — Fri, 14 May 2010 06:14:37 GMT

Hi Vidya,

Macro to Auminimize the sheetobjects

Sub Minimize

Set S=ActiveDocument.Sheets("main")

For i=0 to S.NoofSheetsobjects-1

S.Sheetobjects(i).Minimize)

End Sub

Try the above

Cheers,

Ajay