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:

Public Sub Worksheet_Open()

Save.Left = 60
Save.Top = 60
Save.Width = 230
Save.Height = 45

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

Public Sub Worksheet_Open()


poz_start_kl_l = 750.25                 
poz_start_kl_w = 150.25
szer_kl = 126.75
wys_kl = 32.25

ActiveSheet.Shapes("Button 1").Left = poz_start_kl_l
ActiveSheet.Shapes("Button 1").Top = poz_start_kl_w
ActiveSheet.Shapes("Button 1").Width = szer_kl
ActiveSheet.Shapes("Button 1").Height = wys_kl

Works great.

THX

[Izandol]

You are welcome.