ScrollBar in Excel problem
Hi all,
I have such a problem:
I have a scrollbar on worksheet, but I don't know how to assign a code to it's change event.
I don't want this control to be linked to worksheet's cell using LinkedCell property I would like to assing my own code.
Please help.
Regards,
sweet_dreams
Re: ScrollBar in Excel problem
LOL I managed to do this it was easy in fact.
But now I have another problem. It seams to me that this ActiveX control looks like it is disabled. It don't wont to work. I mean I can't click it scroll arrow, every time I do this window with code opens.
Whats happening?? How can I make this control work properly??
Please help,
Regards,
sweet_dreams
Re: ScrollBar in Excel problem
Oh men I am complete n00b. the design mode was on and thats why it happened me all the time.
problem is solved.