ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need VBA for embedded object????????????? (https://www.excelbanter.com/excel-programming/388607-need-vba-embedded-object.html)

CB

Need VBA for embedded object?????????????
 
I have a workbook that has 3 sheets in it. Sheet 1 is named sensors, Sheet 2
is named Tech Data and Sheet 3 is named Spec Sheets. I have embedded the
spec sheets in cells a1, b1, c1 and D1 in the Spec Sheets Sheet. In the Tech
Data Sheet I have Column F that references the part number that corresponds
to the Spec Sheet in the Spec Sheets Sheet. I would like to be able to click
on F4 of the Tech Data Sheet and it activate C1 in the Spec Sheets sheet. I
don't want to just go to cell C1 in Spec Sheet but would like for the pdf of
the embedded object in C1 Spec sheets to open when I click on F4 in the Tech
Data Sheet. Any help is greatly appreciated.
Clb



All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com