View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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