. Click the 'Start' button or orb on the lower-left corner of your screen. Click 'All Programs' at the bottom, scroll down to Microsoft Office in the alphabetical list, and click it.
Click 'Microsoft Office Excel 2007.' . Click the second tab on the ribbon labeled 'Insert,' and click the 'Hyperlink' icon near the center of the ribbon. Click 'Existing File or Web Page' at the top under 'Link to:' and type the text that you want the hyperlink to display at the top in the text box, such as 'Open PDF.' Click the drop-down arrow directly underneath that box labeled 'Look in:' and find the PDF document you wish to open with the macro. Double-click the PDF file, and a hyperlink will be inserted into your Excel document. Click the Microsoft Office orb on the top-left corner of the screen and click 'Excel Options' button on the bottom-left.
![\ \](http://www.saudimac.com/wp-content/uploads/2010/04/office-mac-2011-direction.jpg)
Office for Mac 2011. Previous updates to the Mac version of Excel, Microsoft's flagship spreadsheet, have largely concentrated on users who use the app for basic everyday tasks.
Click the third check box option from the top, labeled 'Show developer tab in the ribbon.' . Click the eighth tab on the ribbon, 'Developer.' Click the 'Record Macro' button on the top-left. Type a macro name such as 'OpenPDF.' Type 'q' in the text box next to 'CTRL' and under 'Shortcut key.' Write a description in the last text box, such as 'This macro will launch a PDF File.'
. Click the hyperlink you created in Step 2.
If you get a message saying that the hyperlink might be unsafe and asking you if you want to continue anyway, click 'Yes.' Your PDF hyperlink will launch. Click the 'Stop Recording' button on the top-left. Press 'CTRL + q' on your keyboard. Your PDF macro has now been created, and can be launched with the shortcut key 'CTRL + q.' . Was this answer helpful?
Related Questions Q: A:Microsoft Excel provides email functionality through the use of Visual Basic (VBA) macros. These emails may consist of plain text or use HTML. Q: A:There are many helpful tips, tricks and macros (mini-programs for repetitive tasks) for those using Microsoft Excel software. If you are not t.
Q: A: Add macros commands to your regular toolbar. Click on 'Tools' then on 'Customize.' Select the 'Toolbars' tab, then check the box next to 'Vi.
Q: A: Click the 'Tool' menu item and then click 'Macros.' In the list of options, click the 'Macros' icon.
Click 'Workbook' in the list box labe. Q: A: Click on the 'View' menu.
![Sti guns Sti guns](/uploads/1/2/5/3/125388458/756288906.png)
Click 'Macros' 'Record New Macro.' Name your macro by typing into the 'Macro Name' box. For example, type th.