Is it possible to create a bookmark which overrides sheet triggers? I have plenty of sheet triggers in my document and users have created their own bookmarks and if they select those, for example, on first sheet, then sheet triggers overrides bookmark selections. Is there any solution for this or should I remove my sheet triggers (which I really don´t want to do..)
Once try creating one bookmark with action OnOpen->Add(Action)->Bookmark->Apply Bookmark.
Or else see that any trigger with action Clear All was there, is so remove that and by default user created book mark will open based on last action state.
Thanks, it helped a bit. But I don´t know Bookmark ID beforehand, for example if I add action which applies bookmark BM07 but then user creates another bookmark (BM08) and now on that bookmark should applied. So that action (bookmarkID) should be dynamic.
