Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Hi,
I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Hi Hari,
I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Hi Peter,
Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
It is a background. Look in Format=Sheet=Background.
-- Regards, Tom Ogilvy "Hari Prasadh" wrote in message ... Hi Peter, Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Hi,
It seems that the Image is created with Control Toolbox (Toolbar). In design mode you can select the image & delete. Regards, Shah Shailesh http://members.lycos.co.uk/shahweb/ (Excel Addins) *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Is it an Image from the control toolbox? If so you need to go into
Design Mode first in order to select and then delete the control. Cheers Andy Hari Prasadh wrote: Hi Peter, Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Hi Tom,
Its not a background as this graphic is there only in/near cell A1. (its not spread over whole of the worksheet as backgrounds are) Anyway when I go to Format sheet -- background , I get a prompt for applying background. If there had been a background the menu option would have been "Delete Background' Thanks a lot, Hari India "Tom Ogilvy" wrote in message ... It is a background. Look in Format=Sheet=Background. -- Regards, Tom Ogilvy "Hari Prasadh" wrote in message ... Hi Peter, Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Hi Andy and Shailesh
Yes its from design toolbox. Once I pressed on control toolbox - design I could delete it. How can one create such images. I see that if I press on image button it lets me draw rectangles and the formula bar says =EMBED("Forms.Image.1",""). How can I put images from my desktop using this way (the one which was there was blue color petals ). Is there a way where I can mention path etc? Thanks a lot, Hari India "Andy Pope" wrote in message ... Is it an Image from the control toolbox? If so you need to go into Design Mode first in order to select and then delete the control. Cheers Andy Hari Prasadh wrote: Hi Peter, Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
Display the Properties window from the Control toolbox and use the
Picture property to load an image from file into your control. Hari Prasadh wrote: Hi Andy and Shailesh Yes its from design toolbox. Once I pressed on control toolbox - design I could delete it. How can one create such images. I see that if I press on image button it lets me draw rectangles and the formula bar says =EMBED("Forms.Image.1",""). How can I put images from my desktop using this way (the one which was there was blue color petals ). Is there a way where I can mention path etc? Thanks a lot, Hari India "Andy Pope" wrote in message ... Is it an Image from the control toolbox? If so you need to go into Design Mode first in order to select and then delete the control. Cheers Andy Hari Prasadh wrote: Hi Peter, Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message .. . Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Graphic in Excel Workbook
My apologies. I gave you too much credit when you said you couldn't select
it. -- Regards, Tom Ogilvy "Hari Prasadh" wrote in message ... Hi Tom, Its not a background as this graphic is there only in/near cell A1. (its not spread over whole of the worksheet as backgrounds are) Anyway when I go to Format sheet -- background , I get a prompt for applying background. If there had been a background the menu option would have been "Delete Background' Thanks a lot, Hari India "Tom Ogilvy" wrote in message ... It is a background. Look in Format=Sheet=Background. -- Regards, Tom Ogilvy "Hari Prasadh" wrote in message ... Hi Peter, Missed to add this in my original mail. No workbook/sheet protection!! Thanks a lot, Hari India "Peter T" <peter_t@discussions wrote in message ... Hi Hari, I expect sheet protection / objects is on. In graphic format / properties, move & size with cells checked, and print object un-checked. Regards, Peter t "Hari Prasadh" wrote in message ... Hi, I received a workbook from somebody outside my organization. It has a graphic embedded in it (looks like petals of a flower - similar to logo) in cell A1. This is repeated in "Sheet2" and "Sheet3" as well at exactly the same place. If I increase the column width of A then graphic stays at the same place (and its size doesnt change). I wanted to select it and delete it but am not able to. When I get my mouse over the graphic the mouse pointer changes from a PLUS sign to the standard windows pointer type but clicking on it am not able to select it. Strangely this graphic doesnt come out in printouts. What is this graphic and how to delete it? Thanks a lot, Hari India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel graphic planner | Excel Worksheet Functions | |||
Can I add a graphic to a cell in Excel | Excel Worksheet Functions | |||
Excel interfacing with graphic software | New Users to Excel | |||
graphic behind text in Excel? | Excel Discussion (Misc queries) | |||
How do I put a graphic behind the grid in Excel? | Excel Worksheet Functions |