Create a button that would show the data source

sofiabas
sofiabas used Ask the Experts™
on
I would like to create a button called SHOW DATA above the pivot chart, when you click on it it would take you to the data source.
Also, when you are at the data source, you would have another button that allows you to get back to the pivot chart. This button would be called HIDE DATA
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
That would be relatively easy:

- enable the 'Developer' toolbar
- add buttons on the pivot worksheet and the data worksheet
- add code to the button events:

worksheets("[name of the worksheet you want to show]").select

Open in new window


eg
worksheets("Sheet2").select

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial