ScrollBar in Excel problem

[sweet_dreams]

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

[sweet_dreams]

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

[sweet_dreams]

Oh men I am complete n00b. the design mode was on and thats why it happened me all the time.

problem is solved.