Need the API Call (if there is one) to read the status of the scroll bar in an Excel sheet. I want to keep the left most column displayed while scrolling to the right.
Done it in VBA with forms but adds clutter to sheet and it's modal. Thanks
Thanks for the tip..Had it in the code. But it must have been Windows 98..Excel was still in taskman after the programm ran.. Moved to my XP machine and everything works fine,
Thx again
I'm ungrouping a shape,then writing the text out to Excel.
It works great the 1st time I run the macro. The second time Excel opens, but the workbook opens as a Phantom. I'm setting ALL the objects to NOTHING, quitting Excel when the macro ends. If I close out the drawing then reload it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.