Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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....:(