Hi,

I have my sheets set with vba so they go to a1 everytime however, as i'm using panes on my sheet- it can go to a1 but still be offset when you return to sheet- is there anyway of setting a vba that resets the scroll bars to make sure horizontal is far left and vertical at the top??

Hope that makes sense

cheers