Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
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. "Fecozisk" wrote: 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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
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: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
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 DrawGroup 6. Copy the Grouped drawing. 7.Open Windows Paint program. StartAll ProgramsAccessoriesPaint 8. In Paint go EditPaste then go FileSave and name the file "Ellipse" (without the speech marks). Click OK to save. 9. Go back to your workbook then go FormatSheetBackground... 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 FormatSheetDelete background. Ken Johnson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
yeah man! Now this problem is solved! thanks a lot. Very creative! thanks!
"Ken Johnson" escreveu: 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 DrawGroup 6. Copy the Grouped drawing. 7.Open Windows Paint program. StartAll ProgramsAccessoriesPaint 8. In Paint go EditPaste then go FileSave and name the file "Ellipse" (without the speech marks). Click OK to save. 9. Go back to your workbook then go FormatSheetBackground... 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 FormatSheetDelete background. Ken Johnson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
"unselectable" draw????
Hi Fecozisk,
Great! Thanks for the feedback. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How draw x-y picture | Charts and Charting in Excel | |||
Draw Objects in Charts | Charts and Charting in Excel | |||
How to Draw an arc which is 1/4 of a circle? | Charts and Charting in Excel | |||
Can't find draw toolbar?? | New Users to Excel | |||
How to draw chat by entering equation | Charts and Charting in Excel |