Automatically highlighting cells behind an embedded object

[Jaymond]

Hello everyone!

I'm having a hell of a time trying to get excel to automatically highlight the cells behind an embedded object when I have the object selected.

I have an embedded PDF file shown as an icon. What I would like to do is have the cells behind the icon fill in with red when I click on the icon. Then when I select another cell (deselect the icon), I want all the cells behind that icon to return to white. Is this even possible with excel?

 

[Jaymond]

I don't know if that solution will help, as all of my embedded objects are in another sheet. Which is why I was trying to have it set up so that I click on a cell in one sheet, it hyperlinks me to an embedded icon in another sheet, and the icon is automatically highlighted with its red border. Then if I want to move around to other icons on the sheet, the red border will only appear on the icon I have selected.

With the code you gave me, I'm still having problems whereby I can't open the embedded file by double clicking on the icon.

Hmmm, this is a tough one...

 

[Derek]

Hi

Sorry, got me stumped!

Did doubleclick work before? What code was triggered when you did that?

I do not have much experience with pdfs. Maybe someone else reading this can help.

regards
Derek

 

[Jaymond]

Yeah, double clicking on the cell worked before. It would open the file. Now it's disabled for some reason with the code. Weird.

 

[Derek]

Hi
I just embedded a pdf file as an icon and assigned my macro to it and it still opened the pdf file when double-clicked.
Derek

 

[Jaymond]

Hmmm,

Here is the code I have for the sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.DrawingObjects.ShapeRange.Line.Visible = msoFalse
Application.ScreenUpdating = True
End Sub

Here is the code I have for the module (assigned to each embedded PDF file):

Sub RedBorderToggle()
ActiveSheet.DrawingObjects.ShapeRange.Line.Visible = msoFalse
ActiveSheet.Shapes(Application.Caller).Line.Visible = Not ActiveSheet.Shapes(Application.Caller).Line.Visible
End Sub

Is there something wrong with the code?

 

[Jaymond]

For some reason, when clicking on the icon, it's just showing the border, but it's not actually selecting the icon. When an icon is selected, it has the 8 little circles around it (so you can resize it), but with the code above, it doesn't actually select the icon. And there is no way to select the icon unless I right click on it.

 

[Derek]

Hi

I find the doubleclick is very unreliable when you assign a macro to your icon. It seems to work okay when you use my "hyperlink" suggestion above - but it will not then highlight if you actually select the icon, only when you click on the "hyperlink" cell

Derek

 

[Jaymond]

I can't believe you can't select an icon once you assign a macro to it. There has to be something we're missing...

 

[Derek]

Presumably there is a doubleclick event inherent in the icon (to open the pdf file) which is voided when another macro is assigned to it. Try reposting your topic as a different question -- some guru out there will know the answer.

regards
Derek