I have a large number of workbooks with an user form, the user form shows up
when the workbook is open. I am trying to disable one of the option buttons
on the user form. How can I do it programmatically?
Thanks!

JH

OptionButton1.Enabled = False

If this post helps click Yes
---------------
Jacob Skaria


"JH" wrote:

> I have a large number of workbooks with an user form, the user form shows up
> when the workbook is open. I am trying to disable one of the option buttons
> on the user form. How can I do it programmatically?
> Thanks!
>
> JH

if you want it disabled always, you can do that in the userform
properties.

if you want it disabled due to a certain condition when the userform
opens, you can do it programatically in the userform_initialize sub

if xxxxxxxx then
optionbutton1.enabled=false
else
optionbutton1.enabled=true
end if

where "xxxxxxx" is your condition.
hope that helps.

susan



On May 4, 10:32*am, JH <J...@discussions.microsoft.com> wrote:
> I have a large number of workbooks with an user form, the user form showsup
> when the workbook is open. *I am trying to disable one of the option buttons
> on the user form. *How can I do it programmatically?
> Thanks!
>
> JH

Hi,
I added this line to my macro. " frmMenu.opt1.Enabled = false", I got
an error message, "Object required". The macro is located in another
workbook. I am intended to use this macro to loop through all the workbooks
that needed changes.
The code is as follow:

................................
fname = Dir(pname, vbNormal)
Do
If Len(fname) < 28 Then

Workbooks.Open FileName:=pname & fname, UpdateLinks:=False
frmMenu.opt1.Enabled = False
Workbooks(fname).Close saveChanges:=True
End If
fname = Dir() 'get another filename
Loop Until fname = ""
----------------------------------------------
Thanks!
JH

"Jacob Skaria" wrote:

> OptionButton1.Enabled = False
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "JH" wrote:
>
> > I have a large number of workbooks with an user form, the user form shows up
> > when the workbook is open. I am trying to disable one of the option buttons
> > on the user form. How can I do it programmatically?
> > Thanks!
> >
> > JH

since the userform is in another workbook, you need to qualilfy your
workbooks (which you're already doing).

try something like

Workbooks(fname).frmMenu.opt1.Enabled = false

then it knows WHERE to find frmMenu.
hope it helps.

susan


On May 4, 1:51*pm, JH <J...@discussions.microsoft.com> wrote:
> Hi,
> * * *I added this line to my macro. " frmMenu.opt1.Enabled = false", I got
> an error message, "Object required". *The macro is located in another
> workbook. *I am intended to use this macro to loop through all the workbooks
> that needed changes.
> The code is as follow:
>
> ...............................
> fname = Dir(pname, vbNormal)
> Do
> If Len(fname) < 28 Then
>
> * Workbooks.Open FileName:=pname & fname, UpdateLinks:=False
> * frmMenu.opt1.Enabled = False * * * * *
> * Workbooks(fname).Close saveChanges:=True
> End If
> fname = Dir() * *'get another filename
> Loop Until fname = ""
> ----------------------------------------------
> Thanks!
> JH
>
>
>
> "Jacob Skaria" wrote:
> > OptionButton1.Enabled = False
>
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
>
> > "JH" wrote:
>
> > > I have a large number of workbooks with an user form, the user form shows up
> > > when the workbook is open. *I am trying to disable one of the option buttons
> > > on the user form. *How can I do it programmatically?
> > > Thanks!
>
> > > JH- Hide quoted text -
>
> - Show quoted text -