How can I keep an icon in a cell from being moved?

T

TPD

Hello,

Just ran into a strange problem that perhaps has no solution, BUT her
goes:

I have an Excel Document that I inserted (embedded) and external Wor
Doc. into a cell. It displays as an icon and when the user clicks o
it, it opens a separate window with that Word File in it. No issue
there at all. Perfect.

The problem is that even after I protect the sheet, the user can stil
move the icon and even delete it if he or see so chooses. NOT GOOD!!!

If I lock it,..and protect the sheet, then the icon is no longe
accessible to activate...NOT GOOD

If I choose to not display it as an icon in the cell,...then the windo
opens from within the Excel sheet..NOT GOOD

How can I leave the icon in the cell, also keep it functional, but no
allow it to be moved???

I thought perhaps of moving the icon off to the right of th
spreadsheet and perhaps trying to make the cell such that when clicked
it knows to activate the hidden icon,...but perhaps this is not a
intelligent approach. I wouldn't know how to do that anyway....not a
Excel expert here.

Thanks,
T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top