Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link To Embedded Object | Excel Discussion (Misc queries) | |||
Embedded Object Flickering | Excel Discussion (Misc queries) | |||
size of embedded object | Excel Discussion (Misc queries) | |||
Maximize Embedded Object? | Excel Discussion (Misc queries) | |||
error! Not a valid embedded object | Excel Discussion (Misc queries) |