Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ActivateAlso in macro not working

hi,

I found a method in QV API named ActivateAlso

rem ** activate all sheet objects on sheet Main and leave activated **

set s=ActiveDocument.Sheets("Main")

for i=0 to s.NoOfSheetObjects-1

    s.SheetObjects(i).ActivateAlso

next

but its not working.....can anybody write code to activate all object in a sheet..

Thanks in advance

Arun Goel

4 Replies
SunilChauhan
Champion II
Champion II

pleave try this

sub main

rem ** activate all sheet objects on sheet Main and leave activated **

set s=ActiveDocument.Sheets("Main")

for i=0 to s.NoOfSheetObjects-1

    s.SheetObjects(i).Actvate

next

end sub

Sunil Chauhan
Not applicable
Author

I know this function  ....but it will activate all objects one by one and in last...only last object will remain activated...but i need all object should be activated and remain activated.....

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Did you tried with activate all?

    

ActiveDocument.Sheets("Main").ActivateAll


Celambarasan

Not applicable
Author

hi,

thanks  for the reply but there is no such method....:(