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 -