VBA Scroll Areas controls
Posted by Jack on December 07, 2001 9:52 AM
I wish to stop scroll in VBA under Auto_Open, yep simple enought when sheets open, catergorize and set as reqd but i have two requirements
1 To set to A1 dead, ill add an event button to continue si the ss dead as such, i have Wordart thats anomated as so on. you know Happy Christmas appears and dances about a bit. But i cant fint the syntax to do this??
2 i seem to have to refer to a cell as the last object/wordart selection to rotate stays selected?? look really poor, or i select A1 to release that selection but that spoils it to as the secection white cell as background is black, well cells filled black that is, my question is how do i unselect my last wordart object or select a cell but no show its selection if you see what i mean
Ive just these tow bits to do so any help would be a good send, thanks for you advise as always. Jack "UK"