I am having two Sheets with bookmarks object wiht each sheet. In this if i am adding a bookmark in sheet1, the same added bookmark is also having in sheet2.
My requriement is each sheet should show only its added bookmarks.
a bookmark is valid within the whole application. You can't use it only in one (special) sheet.
But you can use an OnOpening-Trigger to apply a bookmark when entering a sheet. Before that you should clear the current selections. Look at: sheet properties --> trigger tab --> add actions --> apply bookmark (maybe it is usefull to add a "clear all"-action before )
