Hiding A Sheet Command Button With VBA
 

Greetings,

I have a Command Button on a worksheet than under some conditions
needs to be hidden. I am trying to hide it from a UserForm. I have
tried:

CommandButton1.Visible = False

In the code to start the next procedure, I get this message in a
"Microsoft Visual Basic" message box:

Compile Error:
Variable not defined

Any suggestions?

TIA

-Minitman

Hiding A Sheet Command Button With VBA
 

Worksheets("sheet1").CommandButton1.Visible = False

--
Regards,
Tom Ogilvy

"Minitman" wrote in message
...
Greetings,

I have a Command Button on a worksheet than under some conditions
needs to be hidden. I am trying to hide it from a UserForm. I have
tried:

CommandButton1.Visible = False

In the code to start the next procedure, I get this message in a
"Microsoft Visual Basic" message box:

Compile Error:
Variable not defined

Any suggestions?

TIA

-Minitman

Hiding A Sheet Command Button With VBA
 

Thanks Tom,

That is just what I was looking for.

On Sat, 6 Mar 2004 19:35:03 -0500, "Tom Ogilvy"
wrote:

Worksheets("sheet1").CommandButton1.Visible = False