Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have qvw file of 15 sheet. and each sheet i have a current slection box.
but i want that what ever i selected into 1st four sheet ,when i move to sheet five does not show in current selection box on sheet five.
i dont want to use clear selection option.actually i want to use current selection box for each sheet in that way so that it will show
only selection what ever made on that particular sheet,when move to next sheet previous sheet selection will not show in current selection box of lethis sheet.
is it possible,Please suggest?
Selections are for the application, not a sheet in the application.
You may be able to use bookmarks to save the selections on each sheet. When you move to a new sheet, you save the selections on the sheet you are moving form and load the BM for the sheet you are moving to.
Hi,
you can use the function GetCurrentSelection() and some if-statements.
Greetings from Munich
Martina
Thanks Martina,
Could u please explain little bit more because i am not able to write any
expression into current selection box.
How can i write expression into current selection box.
Regards,
Anup