Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two sheets sheet1 and sheet2.
When i go to sheet2, i clear all selections and retain few selections in sheet2 from sheet1.
I need to retain the previous selections of sheet1 which were cleared, when i move from sheet2 to sheet1.
How we can achieve this?
You can use sheet triggers.
Use "Replace bookmark" action on "OnLeave Sheet" event to save current selections and "Apply bookmark" action on "OnActivate Sheet" event to apply the saved selection.
Hi Andrea,
I tried this, but also it is not working.
I applied "Replace Bookmark" on sheet1 onleave sheet and "Apply Bookmark" on sheet1 onactivate sheet.
Is this correct?
I tried this method, when i come to sheet1 from sheet2, all the selections are getting cleared.
Try the attached example...
Hi Andrea,
Thanks for the file. It is working now for me.
But the bookmark is not working in Ajax/IE Plugin View.
I'm sorry but it works for me in both environments.