J
jackie
I have four dashbards each with 4 charts containing macros, and each in it's
own workbook. The data for the macros is all in the same workbook. It works
fine.
This morning I had a request to create a table of contents so that the user
could click a button and open a dashboard. I crated this in a separate
workbook. It includes buttons with macros so, if the user clicked on army,
for example, they would go to the dashboard with all of the army information.
I created it in it's own workbook.
Then I decided that if they were going to use a table of contents to go to a
dashboard, I needed a way for them to get back to the TOC. So I created a
button in each dashboard that will take the user back to the TOC. Here's my
problem:
When a user is in the TOC and selects army, he goes to the army dashboard.
Then he selects 'back to TOC" if he wants to return. However, if the user
forgets, and selects army again, one of two things happens; either they get a
message saying the dashboard is already open, and then they get a VB error,
or they are allowed to go back to the dashboard getting no error. But ALWAYS,
when they go back to the dashboard, the chart that has the 'return to TOC"
button loses focus, and they have to click out of the chart and click back
in. By losing focus I mean the chart has three circles on each side instead
of 3 black squares. The user thinks the chart doesn't work.
How do I keep the chart from losing focus. This is my first time creating
macros. Is there someting special I should be doing? Thank you.
own workbook. The data for the macros is all in the same workbook. It works
fine.
This morning I had a request to create a table of contents so that the user
could click a button and open a dashboard. I crated this in a separate
workbook. It includes buttons with macros so, if the user clicked on army,
for example, they would go to the dashboard with all of the army information.
I created it in it's own workbook.
Then I decided that if they were going to use a table of contents to go to a
dashboard, I needed a way for them to get back to the TOC. So I created a
button in each dashboard that will take the user back to the TOC. Here's my
problem:
When a user is in the TOC and selects army, he goes to the army dashboard.
Then he selects 'back to TOC" if he wants to return. However, if the user
forgets, and selects army again, one of two things happens; either they get a
message saying the dashboard is already open, and then they get a VB error,
or they are allowed to go back to the dashboard getting no error. But ALWAYS,
when they go back to the dashboard, the chart that has the 'return to TOC"
button loses focus, and they have to click out of the chart and click back
in. By losing focus I mean the chart has three circles on each side instead
of 3 black squares. The user thinks the chart doesn't work.
How do I keep the chart from losing focus. This is my first time creating
macros. Is there someting special I should be doing? Thank you.