scroll bar to automatically reset- vba?
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
Something like this;
Please Login or Register to view this content.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
HI thanks for the post and seems like that should work but it doesn't- i know you have "sheet 1" there so i replaced that with my sheet which is "ALG" but still doesn't work- i also want to this for all my sheets so if anyone has the answer can you explain with multiple sheets please.
Thank You!
Did you put the code in worksheet module?
Can you plesae explain it in more descriptive way for my better understandingOriginally Posted by davehow87
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks