disable option button on user form
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 |
disable option button on user form
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 |
disable option button on user form
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 |
disable option button on user form
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 |
disable option button on user form
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 - |
All times are GMT +1. The time now is 09:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com