Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing an object being moved around the worksheet
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? Mike suggested "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." BUT unless I am particularly stupid (very likely!) I cannot seem to make this 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
CTRL Find is preventing me from navigating around my worksheet | Excel Discussion (Misc queries) | |||
Can the bottom tabs in Excel be moved vertically on a worksheet? | Excel Discussion (Misc queries) | |||
Draw object pasted into Excel cannot be deleted or moved | Excel Discussion (Misc queries) | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |