Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.....
Hi,
Did you tried with activate all?
ActiveDocument.Sheets("Main").ActivateAll
Celambarasan
hi,
thanks for the reply but there is no such method....:(