Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures tied to rows.
Are pictures tied to rows? If I set the properties of a picture to "Move and
size with cells" and it is within the cell "depth" then it is removed from the sheet if the "parent" row is deleted, yes? Well anyway that is my experience in Excel 2000, but not in Excel 2003, is this all correct so far? Simple question, is there a way of identifying a picture "Embeded" in a Row so that it can be deleted with code? 2000 & 2003. Thanks in advance David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures tied to rows.
Pictures have always been in a layer above cells. I don't recall a picture
being deleted because the row below it is delete. If you want to delete a picture, then delete the picture. Turn on the macro recorder. Select the picture. Hit the delete key. Turn off the macro recorder. That should give you some insights. -- Regards, Tom Ogilvy "David Henderson" wrote: Are pictures tied to rows? If I set the properties of a picture to "Move and size with cells" and it is within the cell "depth" then it is removed from the sheet if the "parent" row is deleted, yes? Well anyway that is my experience in Excel 2000, but not in Excel 2003, is this all correct so far? Simple question, is there a way of identifying a picture "Embeded" in a Row so that it can be deleted with code? 2000 & 2003. Thanks in advance David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures tied to rows.
Tom,
I did that. In my limited experience the picture does seem to be deleted as I described in 2000, and I know it does not in 2003. It can be associated with a cell in Formatting/Properties Size & Position.I think my best bet is to name each picture , just so that I know how to reference in macro code. Thanks for your help David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pictures tied to rows.
If you're deleting the rows in code, try:
With worksheets("whatever") msgbox .pictures.count 'delete your rows msgbox .pictures.count end with I bet that it's just gotten very small. David Henderson wrote: Tom, I did that. In my limited experience the picture does seem to be deleted as I described in 2000, and I know it does not in 2003. It can be associated with a cell in Formatting/Properties Size & Position.I think my best bet is to name each picture , just so that I know how to reference in macro code. Thanks for your help David -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
How do I sort collumns and leave out pictures in rows not used? | Excel Worksheet Functions | |||
Microsoft Query with more than one parameter gets tied up | Excel Discussion (Misc queries) | |||
Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
Summation of cells tied to Checkboxes | Excel Programming |