![]() |
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 |
All times are GMT +1. The time now is 09:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com