Disable a form button

Greetings,

I have a single-sheet workbook, with a button called "Copy Order". How can I disable it? I found this code elsewhere:

Please Login or Register  to view this content.

but when I run it, I get an error that says "Object doesn't support this property or method."

I am running Excel in Office 2001 for Mac.

Thanks!
DM

Hi Mike,

I tried your suggestion, and got this:

Run-time error '1004':

Unable to get the Buttons property of the Worksheet class.

Any other ideas on how I can get this happenin'?

Thanks for your help!
DM

Good morning doctormelodious

Try this :

Please Login or Register  to view this content.

This should disable the button, but if you are using buttons from the Forms toolbar, it won't be greyed out, as Control Toolbox controls are, it just won't work when clicked on. If you want that functionality you'll need to use the Control Toolbox toolbar.

HTH

DominicB

Hey Dominic,

Thanks. That did the trick!

I've been trying to find a list of properties and methods for shapes, but am not having any luck. Can you point me towards this?

Specifically, is there something akin to a "visible" property that would enable me to show/hide a shape?

EDIT: Ack! how come as soon as I post, I end up FINALLY finding the info I was looking for??

http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

Thanks again,
DM

Thanks Mike,

Okay, now here's what's got me stumped. I have created two of these buttons. One would assume that the second button would be "Button 2". But the code you gave me only works when I put "Button 1" in it. I can't make the other button invisible. Putting "Button 2" in gets:

Run-time error '5':

Invalid procedure call or argument

I also tried referring to the button by its name text, but that failed too.

Where do I find out the internal names by which VB refers to these buttons? Opening their Properties just gives me stuff relating to positioning and printing.

Thanks!
DM

Oh Geez... that's TWICE in one thread!!

I found it. The second button is somehow "Button 34"!

Peas-Out,
DM