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

Check your earlier post.

CR wrote:

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

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" wrote in message
...
Check your earlier post.

CR wrote:

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

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.

CR wrote:

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" wrote in message
...
Check your earlier post.

CR wrote:

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

--

Dave Peterson