Help! How do I lock an embeded file icon in a cell??

Status
Not open for further replies.

simon1066

New Member
Joined
Oct 25, 2006
Messages
2
I have tried everyway I know how to fix this but no joy,
Can you help please:

I regularly send out Excel files to suppliers with embeded objects eg .PDF files in specific cells (Using this routine: Insert, Object, Create From File, Browse, Select File, Display As Icon, OK).
The problem is the icon for the embeded file is moveable.
This means someone could move the icon in the spreadsheet and confuse our suppliers. We use 1 icon for each reference and there can be many references in the spreadsheet.
So my question how can I lock the icon for the embeded file in a specific cell?
Many many thanks.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top