"unselectable" draw????

[Guest]

I want to have something (a elipse) drew on my excel file, but i dont want it
to be selected when i click on it (i want to select the cell that is under
it!). What can i do? If i can use a macro, please tell me how (new user...)
thanks,

 

[Guest]

Select the Elipse and from the Drawing Toolbar use No Fill under Fill Colors.
By Default, it is filled by White Color. That is why you are having problem
selecting the cell.

Let us know, if this information is useful to you.

 

[Ken Johnson]

In addition to removing the Fill, you can also unlock the sheet's cells
then protect the sheet. That way, even clicking on the edge of the
ellipse will not select it.

Ken Johnson

 

[Guest]

Hmmm.. almost there! I could protect it to not be selected even if clicking
on the elipse's edge. But the cells under it are very small, and the border
of the elipse arent alowing me to select the cell, which is my goal! Is there
anything i can do to "pretend" that the elipse "doesnt exists"? and if i
click the edge it selects the cell that is under it?
Thanks for everything!



"Ken Johnson" escreveu:

 

[Ken Johnson]

You could try this. It converts your ellipse to a bitmap then uses that
bitmap picture as a watermark (a worksheet background behind the
cells). The only problem with this technique is that your whole
worksheet is covered with multiple copies of the ellipse. Also, the
watermark does not change size when you either change cell sizes or
zoom in or out. So, you would only use this technique if that didn't
matter. It won't matter if for this sheet
(1) your cells keep a constant size
(2) you don't need to scroll down or across to other parts of the sheet
where the other copies of the ellipse have been placed by Excel
(3) you don't need to zoom in or out

Follow these steps to make the watermark...

1. Draw the ellipse. Format it to have no fill. Position it on the
worksheet.
2. Draw a rectangle (AutoShape).Carefully adjust the rectangle's size
so that it is the same size as the visible area of your worksheet.
3. Format it to have no fill and no line.
4.With the invisible rectangle still selected, hold down the Shift key
while you select the Ellipse.
5. With the Ellipse and rectangle both selected go Draw>Group
6. Copy the Grouped drawing.
7.Open Windows Paint program. Start>All Programs>Accessories>Paint
8. In Paint go Edit>Paste then go File>Save and name the file "Ellipse"
(without the speech marks). Click OK to save.
9. Go back to your workbook then go Format>Sheet>Background...
10. Type "Ellipse" (without the speech marks) in the Filename: box of
the dialog that appears, then click on the Insert button.
11. Small adjustments to cell sizes may be needed to get the relative
position of the Ellipse correct.

If you're not satisfied with the result just go Format>Sheet>Delete
background.

Ken Johnson

 

[Guest]

yeah man! Now this problem is solved! thanks a lot. Very creative! thanks!

"Ken Johnson" escreveu:

 

[Ken Johnson]

Hi Fecozisk,

Great!

Thanks for the feedback.

Ken Johnson