Excel Web Access issue

I embedded an excel sheet into sharepoint using the excel web access web part. It works great, the only problem is that it continues to display the excel sheet on refresh where it was last saved. I set up a macro so that when excel opens it opens to a default page, but the macro does not seem to be applying on the initial display of the sheet in sharepoint. Does anyone know how to make sharepoint always display the part of the workbook that i want it to, regardless of where i am at at the time that i save the workbook? any help would be much appreciated.