I have a sheet that contains two chart objects (Label Compliance and Promotional Programs).
I created a bookmark so that one can select either Label Compliance or Promotional Programs and the current selection values are saved in each bookmark.
the problem I'm having is that the bookmark doesnt' know to switch from the Label Compliance chart to the Promotional Programs chart when I select the Promo Prog bookmark.
Is there a way to do this, that is bookmark also the chart as well as the current selections?
I also read a post on this community that said bookmarks also bookmark the sheet within your document but I couldn't get that to work. What I tried was to create Label compliance and Promotional Programs on separate sheets and hope that if i created a bookmark for each, that when i retrieved it, the application would know to open the sheet that corresponded to the bookmark I created.
