The code doesn't work. For the first set of code I get the message "Object
does not support this property or method" and for the second line of the
first set the message is "Unable to get OLE Object property of the worksheet
class"

For second set I get this message for the first line "Variable Not Defined"
and it indicates userform1 and for the second line I get the same message.
As far as I know I have not created a form, only buttons using the Forms Menu.
"Tom Ogilvy" wrote:

Activesheet.Commandbutton1.Visible = False
Activesheet.OleObjects("Commandbutton1").Visible = False

on a userform

Userform1.Commandbutton1.Visible = False
Userform1.Controls("CommandButton1").visible = False

--
Regards,
Tom Ogilvy


"JR_06062005" wrote:

I think I didnt phrase my question correctly. I did not want a yes/no
answer as I had already suspected there was a way to do this, but I dont
know how to identify the command button object. I suppose the code is
something like:

Commandbutton(button identifier).visible=false €˜to make invisible
Commandbutton(button identifier).enable=false €˜to disable

I certainly would appreciate a little more help.


"Harald Staff" wrote:

Sure, commandbuttons have an Enabled property and a Visible property, both
can be set to False.

HTH. Best wishes Harald

"JR_06062005" skrev i melding
...
Is there a way to make a command button invisible and/or disable it? This
can be done in Access, but if it can be done in Excel, I don't know how to
do
it.