Clear contend of Pivot table on close.

Hi All, your help would be much appreciated on the following. I am still a novice on VBA. I have created some code for excel 2007 which I have included below. The code on a click of a button opens a Pivot Table but it only brings back data for the user (Lan ID). What I would like to do is on close/exit clear all data in the pivot so when another user opens the Excel Spreadsheet it will not be populated with the last persons information.

Thank you

Please Login or Register  to view this content.

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
Then anyone will be able to help you.