| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't delete a picture
I have a huge shared spreadsheet that someone has inserted a picture on it.
The person that put that picture in is no longer with the company so I can not ask them what they did. This picture can not be moved, reduced, or deleted by any means that I know of. I have highlighted all the cells and deleted them and this picture is the only thing that remains. I have copied all the cells and pasted them into a new workbook and the picture transfers also. I checked already and there is no macro linked to this picture. If you try and click on the picture the pointer changes to make it look like you could move it but I can't make it do anything. I'm lost as to what I can do. Any ideas on what may be going on here? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't delete a picture
Hi,
You might try: 1. Copy all the cells but choose Edit, Paste Special, Formulas, followed by Paste Special, Formats. Can you select the picture? 2. Select all the cell except those where the picture is and copy those and paste them. -- Thanks, Shane Devenshire "Cerberus" wrote: I have a huge shared spreadsheet that someone has inserted a picture on it. The person that put that picture in is no longer with the company so I can not ask them what they did. This picture can not be moved, reduced, or deleted by any means that I know of. I have highlighted all the cells and deleted them and this picture is the only thing that remains. I have copied all the cells and pasted them into a new workbook and the picture transfers also. I checked already and there is no macro linked to this picture. If you try and click on the picture the pointer changes to make it look like you could move it but I can't make it do anything. I'm lost as to what I can do. Any ideas on what may be going on here? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't delete a picture
Sharing is a type of protection. To have full control to modify the sheet you
need to unshare the workbook... -- HTH... Jim Thomlinson "Cerberus" wrote: I have a huge shared spreadsheet that someone has inserted a picture on it. The person that put that picture in is no longer with the company so I can not ask them what they did. This picture can not be moved, reduced, or deleted by any means that I know of. I have highlighted all the cells and deleted them and this picture is the only thing that remains. I have copied all the cells and pasted them into a new workbook and the picture transfers also. I checked already and there is no macro linked to this picture. If you try and click on the picture the pointer changes to make it look like you could move it but I can't make it do anything. I'm lost as to what I can do. Any ideas on what may be going on here? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't delete a picture
Hi again,
One other thing came to mind, maybe the spreadsheet is protected, choose Tools, Protection and see if Unprotect Spreadsheet is an option. If it is you can unprotect the spreadsheet and delete the picture. If any of this helps, please click the Yes button. -- Thanks, Shane Devenshire "Cerberus" wrote: I have a huge shared spreadsheet that someone has inserted a picture on it. The person that put that picture in is no longer with the company so I can not ask them what they did. This picture can not be moved, reduced, or deleted by any means that I know of. I have highlighted all the cells and deleted them and this picture is the only thing that remains. I have copied all the cells and pasted them into a new workbook and the picture transfers also. I checked already and there is no macro linked to this picture. If you try and click on the picture the pointer changes to make it look like you could move it but I can't make it do anything. I'm lost as to what I can do. Any ideas on what may be going on here? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't delete a picture
Formatsheetdelete background??
Cheers Simon Blog: www.smurfonspreadsheets.net Cerberus wrote: I have a huge shared spreadsheet that someone has inserted a picture on it. The person that put that picture in is no longer with the company so I can not ask them what they did. This picture can not be moved, reduced, or deleted by any means that I know of. I have highlighted all the cells and deleted them and this picture is the only thing that remains. I have copied all the cells and pasted them into a new workbook and the picture transfers also. I checked already and there is no macro linked to this picture. If you try and click on the picture the pointer changes to make it look like you could move it but I can't make it do anything. I'm lost as to what I can do. Any ideas on what may be going on here? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't delete a picture
On Oct 25, 8:29*am, Cerberus wrote:
I have a huge shared spreadsheet that someone has inserted a picture on it. * The person that put that picture in is no longer with the company so I can not ask them what they did. *This picture can not be moved, reduced, or deleted by any means that I know of. *I have highlighted all the cells and deleted them and this picture is the only thing that remains. *I have copied all the cells and pasted them into a new workbook and the picture transfers also. *I checked already and there is no macro linked to this picture. *If you try and click on the picture the pointer changes to make it look like you could move it but I can't make it do anything. *I'm lost as to what I can do. *Any ideas on what may be going on here? Have you tried... View|Toolbars|Control Toolbox|Click the Design Mode button(Set Square, ruler and Pencil)|Right click the picture|Cut|Click the Design Mode button again to get out of Design Mode. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
| insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
| Macro to delete various pictures and hyper-link picture icons | Excel Worksheet Functions | |||
| delete picture with macro | Excel Discussion (Misc queries) | |||
| DELETE A PICTURE | Excel Discussion (Misc queries) | |||
Linear Mode
