Reference Command Button

[CR]

I have a worksheet, we'll say Sheet 1, that does a web query. I have two
command buttons setup that turn the query on/off.

On either the workbook Open or Beforeclose, I want to make one of the
buttons visible = false.

When I put the code in ThisWorkbook module, I don't seem to know how to
reference the button (or maybe the sheet?)

I get an object required error as soon as it gets to my Cmd_Stop.Visible =
False line.
How do I properly point to it?


Thanks

 

[Dave Peterson]

Check your earlier post.

I have a worksheet, we'll say Sheet 1, that does a web query. I have two
command buttons setup that turn the query on/off.

On either the workbook Open or Beforeclose, I want to make one of the
buttons visible = false.

When I put the code in ThisWorkbook module, I don't seem to know how to
reference the button (or maybe the sheet?)

I get an object required error as soon as it gets to my Cmd_Stop.Visible =
False line.
How do I properly point to it?

Thanks

 

[CR]

Sorry about the double post.
It was my first post using Giganews. When I hit send on the first one I got
an error saying my password was wrong and it couldn't send. I retyped my
password and recived no error the second time.
CR

 

[Dave Peterson]

Not a problem.

But my reply serves a couple of purposes. First, it tells you that you do have
a response and second, it tells others that you have a response.