|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 20th, 2010, 03:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Visible Shapes in a frame?
Every time I exit design mode, the shapes in a frame disappear behind the
frame. Is there a way to stop that from happening? 
|
|
#2
April 20th, 2010, 04:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visible Shapes in a frame?
I assume you got a frame control from the Control Toolbox? That one is a bit
finicky to use. Right click on the Frame object and select Edit Frame. The Toolbox you get in VBA will appear and you can drag an image control onto the frame. Rick click the image control and select properties to define the image. One thing to be ware of is that it has the tendancy to crash XL. Have you considered using the fram control from the forms toolbar. It is much less finicky and more straight forward to use... -- HTH... Jim Thomlinson "Pas" wrote: Every time I exit design mode, the shapes in a frame disappear behind the frame. Is there a way to stop that from happening?
|
|
#3
April 20th, 2010, 05:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visible Shapes in a frame?
Hi Jim,
I inserted a frame from forms tool bar, then added a shape but with no success, it the shape still diappears when I click off design mode. Is there something in properties I should be doing? "Jim Thomlinson" wrote: I assume you got a frame control from the Control Toolbox? That one is a bit finicky to use. Right click on the Frame object and select Edit Frame. The Toolbox you get in VBA will appear and you can drag an image control onto the frame. Rick click the image control and select properties to define the image. One thing to be ware of is that it has the tendancy to crash XL. Have you considered using the fram control from the forms toolbar. It is much less finicky and more straight forward to use... -- HTH... Jim Thomlinson "Pas" wrote: Every time I exit design mode, the shapes in a frame disappear behind the frame. Is there a way to stop that from happening?
|
|
#4
April 20th, 2010, 05:52 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visible Shapes in a frame?
The frame control from the forms toolbar is transparent and does not change
based on the sheet being in design mode... Sounds like I am missing something in what you are doing. -- HTH... Jim Thomlinson "Pas" wrote: Hi Jim, I inserted a frame from forms tool bar, then added a shape but with no success, it the shape still diappears when I click off design mode. Is there something in properties I should be doing? "Jim Thomlinson" wrote: I assume you got a frame control from the Control Toolbox? That one is a bit finicky to use. Right click on the Frame object and select Edit Frame. The Toolbox you get in VBA will appear and you can drag an image control onto the frame. Rick click the image control and select properties to define the image. One thing to be ware of is that it has the tendancy to crash XL. Have you considered using the fram control from the forms toolbar. It is much less finicky and more straight forward to use... -- HTH... Jim Thomlinson "Pas" wrote: Every time I exit design mode, the shapes in a frame disappear behind the frame. Is there a way to stop that from happening?
|
|
#5
April 21st, 2010, 08:13 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Visible Shapes in a frame?
Hi Jim,
OK, I have a worksheet where I have used shapes to make a aircraft shape. I then inserted a frame from the tool bar control and draged the shapes (aircraft) on to the frame. But, everytime I deselect design mode the shapes disappear behind the frame?!? Is there anything that can be done so that the aircraft shape stays in front of the frame? "Jim Thomlinson" wrote: The frame control from the forms toolbar is transparent and does not change based on the sheet being in design mode... Sounds like I am missing something in what you are doing. -- HTH... Jim Thomlinson "Pas" wrote: Hi Jim, I inserted a frame from forms tool bar, then added a shape but with no success, it the shape still diappears when I click off design mode. Is there something in properties I should be doing? "Jim Thomlinson" wrote: I assume you got a frame control from the Control Toolbox? That one is a bit finicky to use. Right click on the Frame object and select Edit Frame. The Toolbox you get in VBA will appear and you can drag an image control onto the frame. Rick click the image control and select properties to define the image. One thing to be ware of is that it has the tendancy to crash XL. Have you considered using the fram control from the forms toolbar. It is much less finicky and more straight forward to use... -- HTH... Jim Thomlinson "Pas" wrote: Every time I exit design mode, the shapes in a frame disappear behind the frame. Is there a way to stop that from happening?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
