Getting an embedded object to stay put
 

I have created a workbook with various embedded pdf files using icons which I
want to physically fix in position so that they cannot be dragged around the
sheet and misalingned with the text by the user. On the other hand, ther
user must be able to click on the icon and access the embedded pdf document.
Is this possible?
--
paul

Getting an embedded object to stay put
 

Simply protect the sheet making sure 'allow users to edit objects' is
un-checked.

Selecting all cells and removing the locked checkmark means users will still
be allowed to edit cells.

Mike

"paulsuk" wrote:

I have created a workbook with various embedded pdf files using icons which I
want to physically fix in position so that they cannot be dragged around the
sheet and misalingned with the text by the user. On the other hand, ther
user must be able to click on the icon and access the embedded pdf document.
Is this possible?
--
paul

Getting an embedded object to stay put
 

Mike thanks for that BUT unless I am particularly stupid I cannot seem to
make your solution do what I need it to. I can format all cells to be locked
and I can protect the worksheet allowing users to edit the object but this
still allows the user to drag the icon to any cell and then save the change
so that when he/she opens it up again, the icon is where he/she left it and
not where I want it to be.

What I suppose I am looking for is to associate the icon/object with a
specified cell and allow the user to open it but not to move it to another
cell.
--
paul


"Mike" wrote:

Simply protect the sheet making sure 'allow users to edit objects' is
un-checked.

Selecting all cells and removing the locked checkmark means users will still
be allowed to edit cells.

Mike

"paulsuk" wrote:

I have created a workbook with various embedded pdf files using icons which I
want to physically fix in position so that they cannot be dragged around the
sheet and misalingned with the text by the user. On the other hand, ther
user must be able to click on the icon and access the embedded pdf document.
Is this possible?
--
paul