I have been using VB in excel to create user forms. I then have a "button"
that calls the sub "runform1" and the form opens to use. I thought I would
try controls right in the spreadsheet in place of the userform. I did this
using the controls toolbox toolbar. The controls worked fine with one
exception. I cannot enable or disable control buttons as I could with the
user form. Typially I like to enable or disable control buttons depending on
what the user is doing at that time.

Any suggestions? Can control buttons be enabled and disabled using controls
right in the spreadsheet?

Thank you,
Tom

activesheet.oleobjects("CommandButton1").enabled=false


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stinson" <(E-Mail Removed)> wrote in message
news:37E35C70-C4D4-455B-A7CA-(E-Mail Removed)...
>I have been using VB in excel to create user forms. I then have a "button"
> that calls the sub "runform1" and the form opens to use. I thought I
> would
> try controls right in the spreadsheet in place of the userform. I did
> this
> using the controls toolbox toolbar. The controls worked fine with one
> exception. I cannot enable or disable control buttons as I could with the
> user form. Typially I like to enable or disable control buttons depending
> on
> what the user is doing at that time.
>
> Any suggestions? Can control buttons be enabled and disabled using
> controls
> right in the spreadsheet?
>
> Thank you,
> Tom
>
>

Bob,

I tried the code that you suggested and get a run time error, unable to get
the OLEObjects property of the worksheet class. I think the code is pretty
much what I need, just some small aspect isn't right. I haven't had time to
try to figure out what's wrong. I will try the excel help and see what I can
figure out tonight.

Thanks again,
Tom



"Bob Phillips" wrote:

> activesheet.oleobjects("CommandButton1").enabled=false
>
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "stinson" <(E-Mail Removed)> wrote in message
> news:37E35C70-C4D4-455B-A7CA-(E-Mail Removed)...
> >I have been using VB in excel to create user forms. I then have a "button"
> > that calls the sub "runform1" and the form opens to use. I thought I
> > would
> > try controls right in the spreadsheet in place of the userform. I did
> > this
> > using the controls toolbox toolbar. The controls worked fine with one
> > exception. I cannot enable or disable control buttons as I could with the
> > user form. Typially I like to enable or disable control buttons depending
> > on
> > what the user is doing at that time.
> >
> > Any suggestions? Can control buttons be enabled and disabled using
> > controls
> > right in the spreadsheet?
> >
> > Thank you,
> > Tom
> >
> >
>
>
>

Maybe its forms buttons

activesheet.buttons("Button 1").enabled=false


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stinson" <(E-Mail Removed)> wrote in message
news:4B16079C-C84F-4D00-A4A4-(E-Mail Removed)...
> Bob,
>
> I tried the code that you suggested and get a run time error, unable to
> get
> the OLEObjects property of the worksheet class. I think the code is
> pretty
> much what I need, just some small aspect isn't right. I haven't had time
> to
> try to figure out what's wrong. I will try the excel help and see what I
> can
> figure out tonight.
>
> Thanks again,
> Tom
>
>
>
> "Bob Phillips" wrote:
>
>> activesheet.oleobjects("CommandButton1").enabled=false
>>
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>> "stinson" <(E-Mail Removed)> wrote in message
>> news:37E35C70-C4D4-455B-A7CA-(E-Mail Removed)...
>> >I have been using VB in excel to create user forms. I then have a
>> >"button"
>> > that calls the sub "runform1" and the form opens to use. I thought I
>> > would
>> > try controls right in the spreadsheet in place of the userform. I did
>> > this
>> > using the controls toolbox toolbar. The controls worked fine with one
>> > exception. I cannot enable or disable control buttons as I could with
>> > the
>> > user form. Typially I like to enable or disable control buttons
>> > depending
>> > on
>> > what the user is doing at that time.
>> >
>> > Any suggestions? Can control buttons be enabled and disabled using
>> > controls
>> > right in the spreadsheet?
>> >
>> > Thank you,
>> > Tom
>> >
>> >
>>
>>
>>