I have an object that I want to prevent the user from modifying. It's a link to another spreadsheet. I created it like this. On the Insert toolbar,
Insert-Object-Create from File
Navigate to file and select it
Check off Link to file and Display as icon
Click OK
I want the user be able to click on the icon and open the file, but I don't want the to be able to resize or move the icon.
If I protect the sheet, the icon can't be moved or resized, but it's also not clickable. Is there a way to lock the object while still allowing the user to click on it?
I've attached a screen shot of the page.
Bookmarks