Hide picture handles

M

Mafome

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?
 
D

Dave Peterson

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.
 
Top