 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008How to hide the Group Box lines around options buttons??
I'm working on my first Excel form and need to create option buttons with Excel's forms toolbar. After making several sets of Group Boxes, I can't figure out how to remove the Group Box frame surrounding the option buttons. I know it's something very simple but would appreciate your help. Thanks, Charlie charlie6067 You can hide the groupboxes in code--I don't think that there's any other way. Hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter. activesheet.groupboxes.visible = false If you only want to hide a single groupbox, you can use something like: activesheet.groupboxes("group box 1").visible = false > I'm working on my first Excel form and need to create option buttons > with Excel's forms toolbar. After making several sets of Group Boxes, [quoted text clipped - 5 lines] > Charlie > charlie6067  SignatureDave Peterson > You can hide the groupboxes in code--I don't think that there's any other way. > [quoted text clipped - 21 lines] > > Dave Peterson Hi Dave - When I reopened the Excel template, the code was missing in the immediate window. Any ideas? I know I saved it. Thanks for your help, Charlie charlie6067 > > You can hide the groupboxes in code--I don't think that there's any other way. > [quoted text clipped - 30 lines] > > - Show quoted text - Dave - I had removed the Enter keystroke by mistake. Added it back in and it worked fine. Thank you. I really learned something new today. Charlie charlie6067 > > > You can hide the groupboxes in code--I don't think that there's any other way. > [quoted text clipped - 38 lines] > > - Show quoted text - Regarding my last e-mail, everything's working great now. I had made the Group boxes too narrow and that was not allowing the option buttons to remain exclusive. After enlarging the Group boxes, everything works as expected. Many thanks for your help today. I learned something new which is always a good thing in IT to keep your job. Charlie charlie6067 Glad you got it working. > > > > You can hide the groupboxes in code--I don't think that there's any other way. > > [quoted text clipped - 48 lines] > Charlie > charlie6067 SignatureDave Peterson Hi Dave, Your suggestion on the group box (hiding the lines) helped me also! Can you tell me ... is there a way in VBE to change the font size ---- I want to make the font larger. Thank you!!! Chris. Change the font size of what? > Hi Dave, > [quoted text clipped - 5 lines] > Thank you!!! > Chris. SignatureDave Peterson Change the font size of the text that shows up in the box ... the actual size of the words listed next to the button. The font type and size buttons are greyed out when entering the name of the button. Thanks, Chris. > Change the font size of what? > > > Hi Dave, > [quoted text clipped - 9 lines] > > Dave Peterson The caption for the optionbuttons from the Forms toolbar can't be resized. But you could use the optionbuttons from the control toolbox toolbar and change the font (and size) in the properties window for each optionbutton. But these are not grouped the same way. Each set of optionbuttons in a group has a common groupname property. Different groupnames mean different groups. > Change the font size of the text that shows up in the box ... the > actual size of the words listed next to the button. The font type and [quoted text clipped - 18 lines] > > > > Dave Peterson SignatureDave Peterson Hello: I tried this earlier today and it worked perfectly. I decided I wanted the group boxes back on so I typed in activesheet.groupboxes.visible = true - saved that and then opened it later and just deleted it out. Now I dont seem to be able to hide them again. I have followed the instructions and entered activesheet.groupboxes.visible = false I get a runtime error 1004 Unable to set Visiable property of groupbox class. Do you know what might be the problem? Thanks! Tim Are you sure that the activesheet had any groupboxes in it? > Hello: > [quoted text clipped - 14 lines] > Thanks! > Tim SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.