Excel Share file CommandButton resize Problem

[Deredrum]

Hi all

I have a problem with Excel share file.
I try to resize commondbuttons when file is in use.

My code:

Please Login or Register  to view this content.

But I getting statement:

Run-time error 1004: Unable to set the left property of the OLEObject class

I must used this code becouse commandButton (i don't know why) automaticly resizes.

Someone recognizes this problem?

[Izandol]

You may not change properties of OLEobjects in Shared Workbook. May you try to use Forms button instead of ActiveX button? It is possible it will not resize like ActiveX version.

[Deredrum]

Hi

Thanks for answer.

You are right. I used Form Button

Please Login or Register  to view this content.

Works great.

THX

[Izandol]

You are welcome.