This is a problem I am having problems finding a solution for on the net and I would like to publish the solution in several places so that people having the problem can find it easier via google groups etc.

The problem: I have saved several pivot table forms and charts as Data Access Pages. I like users to be able to both view and print this data. The only problem is that page setup does not allow for making the pivot table fit to page. I am using IE 6.0. I have heard that there is possible VBA script that I could insert into the script editor to fix this problem. If anyone coudl help me with this issue I would be so appreciative. Thanks, Justin