Hello to All! This is my first post here! I have undertaken a project that originally was going to be just for my personal use, but now I have ambitions of making this available to a small set of End-Users. What I am looking to do is upon "show details" of a pivot table.. a new sheet opens up... showing the data beneath. In that sheet I'd like to provide a button (either in the ribbon or the page) to kick off a VBA code that creates a KML file from predetermined fields. It then launches Google Earth and displays the data. Now, I've been dabbling around with KML creation from VBA and I've been able to do it directly from my Access Queries, so I think I may be okay with that part of the project (Suggestions or code that some of you have come upon is always appreciated). The issue I have is two fold:

1. Upon double clicking a number in a pivot table to "show details".. a new sheet is created... How do I embed a "button" into all "new" sheets? So that the "user" would only have to click the button to see the information geographically?
or...
2. How do I create a button in the ribbon to always execute code based off of data in the "active" sheet?


Data for the project-

I have created a dashboard of sorts from Linked Tables in Access... connected via ODBC to a larger database. I basically use Access to Query/relate data and then link that query to Excel. (probably not the ideal way but I was originally creating this for my purposes only).


Any ideas or tips to get started would be appreciated. I am a novice user of VBA but I am learning everyday! Thank you!

Joe