| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi, how do you get rid/make the box around grouped buttons clear?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons clear?
I use a white rectangle, put the group box behind the rectangle and the
grouped buttons in front of it. Not too elegant, but it works. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "robbieswife2b" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons clear?
Is this a groupbox from the Forms toolbar?
If yes, you can hide the groupbox in code. Or with just a one liner: 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 robbieswife2b wrote: -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons clear?
Good idea. I guess since it can't be hidden in the UI, I just never tried it
in code. You'd have to remember it was hidden when you had to move your controls around. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave Peterson" wrote in message ... Is this a groupbox from the Forms toolbar? If yes, you can hide the groupbox in code. Or with just a one liner: 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 robbieswife2b wrote: -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons cle
Hello I tried to hide the groupbox as describe below and nothing happens
what I'm I missing My Steps I Hit Alt F11 then ctrl G I typed copied in the immediate , activesheet.groupboxes.visible = false hit enter went back to the excel sheet and the box is still visible around the 2 buttons. "Dave Peterson" wrote: Is this a groupbox from the Forms toolbar? If yes, you can hide the groupbox in code. Or with just a one liner: 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 robbieswife2b wrote: -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons cle
Are you sure that the sheet with the groupboxes was the activesheet?
Are you sure you used a groupbox (and not a rectangle or some other shape)? Wanna Learn wrote: Hello I tried to hide the groupbox as describe below and nothing happens what I'm I missing My Steps I Hit Alt F11 then ctrl G I typed copied in the immediate , activesheet.groupboxes.visible = false hit enter went back to the excel sheet and the box is still visible around the 2 buttons. "Dave Peterson" wrote: Is this a groupbox from the Forms toolbar? If yes, you can hide the groupbox in code. Or with just a one liner: 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 robbieswife2b wrote: -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons cle
Thanks Dave
I have Excel 2002 ...Just to test this....I started with a new workbook... added 3 buttons from the forms tool bar then added the group box from the forms toolbar when I hit Alt F11 the window that comes up says Microsoft Visual Basics - Book 7 then I hit ctrl G the immediate window comes up then I added activesheet.groupboxes.visible = false return to the worksheet and the boxes are still visible I also tried from the active sheet view code which brings me to Microsoft Visual Basic - Book 7 - [Sheet 1 (Code)] I hit ctrl G then I added to the immediate window activesheet.groupboxes.visible = false In both cases when I return to sheet 1 the boxes are still there Again Thank you Dave "Dave Peterson" wrote: Are you sure that the sheet with the groupboxes was the activesheet? Are you sure you used a groupbox (and not a rectangle or some other shape)? Wanna Learn wrote: Hello I tried to hide the groupbox as describe below and nothing happens what I'm I missing My Steps I Hit Alt F11 then ctrl G I typed copied in the immediate , activesheet.groupboxes.visible = false hit enter went back to the excel sheet and the box is still visible around the 2 buttons. "Dave Peterson" wrote: Is this a groupbox from the Forms toolbar? If yes, you can hide the groupbox in code. Or with just a one liner: 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 robbieswife2b wrote: -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hi, how do you get rid/make the box around grouped buttons cle
Did you hit enter after you typed:
activesheet.groupboxes.visible = false into the immediate window It worked for me. Just in case the wrong worksheet is the activesheet, you could try: worksheets("sheet1").groupboxes.visible = false (make sure you hit enter after you type this) Wanna Learn wrote: Thanks Dave I have Excel 2002 ...Just to test this....I started with a new workbook... added 3 buttons from the forms tool bar then added the group box from the forms toolbar when I hit Alt F11 the window that comes up says Microsoft Visual Basics - Book 7 then I hit ctrl G the immediate window comes up then I added activesheet.groupboxes.visible = false return to the worksheet and the boxes are still visible I also tried from the active sheet view code which brings me to Microsoft Visual Basic - Book 7 - [Sheet 1 (Code)] I hit ctrl G then I added to the immediate window activesheet.groupboxes.visible = false In both cases when I return to sheet 1 the boxes are still there Again Thank you Dave "Dave Peterson" wrote: Are you sure that the sheet with the groupboxes was the activesheet? Are you sure you used a groupbox (and not a rectangle or some other shape)? Wanna Learn wrote: Hello I tried to hide the groupbox as describe below and nothing happens what I'm I missing My Steps I Hit Alt F11 then ctrl G I typed copied in the immediate , activesheet.groupboxes.visible = false hit enter went back to the excel sheet and the box is still visible around the 2 buttons. "Dave Peterson" wrote: Is this a groupbox from the Forms toolbar? If yes, you can hide the groupbox in code. Or with just a one liner: 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 robbieswife2b wrote: -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find excisting values, make them grouped under the new value | Excel Discussion (Misc queries) | |||
| Make instructions clear, concise and in plain english. | Excel Discussion (Misc queries) | |||
| Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) | |||
| make autofilter buttons more discernable? | Excel Discussion (Misc queries) | |||
| excel buttons grouped on taskbar | Excel Discussion (Misc queries) | |||
Hybrid Mode
