If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide picture handles
I have received an excel file with a picture as a logo.
There is no direct way of selecting the picture - no picture handles would appear as the mouse pointer goes over. Hence, it cannot be moved, copy or edited. There is no protection in the workbook either. Very cool, I liked it and want to do the same! Easy said but not done. I managed to bring the handles up to manipulate the picture, but what I want to learn in the first place, is how to hide the picture handles. Any knowledgable guru willing to help? |
#2
|
|||
|
|||
Hide picture handles
If you click on Tools|Protection, do you see:
Unprotect Sheet? Maybe the worksheet is protected, but allows you to change the cells--but not the picture. I could do this in a macro: Option Explicit Sub testme01() Dim wks As Worksheet Set wks = Worksheets("sheet1") wks.Protect DrawingObjects:=True, contents:=False, Scenarios:=False End Sub And it matches what you describe--except for the protection. Mafome wrote: I have received an excel file with a picture as a logo. There is no direct way of selecting the picture - no picture handles would appear as the mouse pointer goes over. Hence, it cannot be moved, copy or edited. There is no protection in the workbook either. Very cool, I liked it and want to do the same! Easy said but not done. I managed to bring the handles up to manipulate the picture, but what I want to learn in the first place, is how to hide the picture handles. Any knowledgable guru willing to help? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
publisher 2002 picture frame | whiteshark | Publisher | 3 | May 24th, 2004 09:22 PM |
Word cannot edit word picture object | Alvin | New Users | 2 | May 22nd, 2004 12:31 AM |
3-D Chart background picture prints only partly | Pirjo Arosara | Charts and Charting | 0 | February 11th, 2004 11:13 AM |
Truncated Picture? | Ari Blum | Worksheet Functions | 1 | October 27th, 2003 08:45 PM |