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 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

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 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 -