I need to do this in vba because of process I have already setup. My team, using a tool I created, process hundreds of contracts (which are built using macros) but all tabs do not show because of the scrollbar. Usually this would be a mute point, but these files are built for sales reps and most are excel challenged. The whole process is automated except for having to open each file and adjust the scrollbar(bottom). Without the adjustment all tabs are not utilized by the sales force (at least the challenged ones).
any takers.... or am I just going down a void road....
I have serched this board and MSDN with no luck.....