jdurbin
08-23-2016, 09:10 AM
I am currently using Excel 2013. I created a spreadsheet to share with a few hiring managers so that they could review the individuals who have applied for a position that we have open. The spreadsheet has three sheets. On the first sheet is named candidates and I have the individuals name (FN, LN,), contact numbers, etc.. The second sheet is my data validation sources. The third sheet is where I have the resumes of the individuals. I embedded the resumes as objects on this page. There are 50+ embedded resumes on this page.
I have read some post where individuals had placed a code in to link or create a command button to an embedded document from one sheet to another but it only referred to linking one document. I need to create links\command buttons for each documents (resumes) that are embedded objects.
What I wanted to do was to create a cell next to each candidates name and create a command button (name it resume) to link the embedded resume\object on page three.
What code would I need to do to link the resumes\objects from sheet 3 (named resumes) to the command buttons on sheet 1 (named candidates)?
Thank you
I have read some post where individuals had placed a code in to link or create a command button to an embedded document from one sheet to another but it only referred to linking one document. I need to create links\command buttons for each documents (resumes) that are embedded objects.
What I wanted to do was to create a cell next to each candidates name and create a command button (name it resume) to link the embedded resume\object on page three.
What code would I need to do to link the resumes\objects from sheet 3 (named resumes) to the command buttons on sheet 1 (named candidates)?
Thank you