Run-time error 438

[mrsteele]

Hi.
I'm new to writing Macros so require some assistance. A previous colleague was pretty ace at doing these, so I've written similar coding to the previous sheet he had used.
I've written the code out now, but an error keeps popping up, and it;s regarding making some buttons visible/invisible. I've typed out;
sheets("PO Form").button14.visible = true
sheets("po form").button16.visible=false
Button 14 is the one thats come up with an error, saying 'object doesn't support this property or method' - i've no clue what this means...if someone can put this into plain English, it will be very helpful (or even recomend a code to use to make buttons visible/invisible)

Thank you!

 

[Zot]

Are you talking about CommandButton? There are ActiveX Controls and Form Controls CommandButton. The one that are having caption Button1, Button2 and so on belong to the Form Controls. These do not have Visible properties. Use the ActiveX one

 

[RoryA]

These do not have Visible properties

Yes, they do, you just refer to the object differently. Form controls are more stable than ActiveX too.

You'd use something like:

With sheets("PO Form")
    .buttons("Button 14").visible = true
    .buttons("Button 16").visible=false
end with

 

[mrsteele]

Genius! That coding worked.
I did read online that activeX controls were more fiddly and that form controls were easier to manage if the right Macro was assigned.

 

[Zot]

Yes, they do, you just refer to the object differently. Form controls are more stable than ActiveX too.

You'd use something like:

With sheets("PO Form")
    .buttons("Button 14").visible = true
    .buttons("Button 16").visible=false
end with

I see. Thanks for the info