![]() |
Macro to Execute Hyperlink
Cell F5 is being populated by a ComboBox. If cell F5 has the following text,
I want Excel to execute an associated hyperlink: Cell F5 Hyperlink address ----------------- ----------------------------------------- Facilities C:\Documents and Settings\....\Facilities.xls Maintenance C:\Documents and Settings\....\Maintenance.xls Overhead C:\Documents and Settings\....\Overhead.xls For example, if the user selects €śFacilities€ť from the ComboBox, the macro would execute the hyperlink contained in the code, taking the user to the Excel workbook C:\....Facilities.xls. What would the code be? |
All times are GMT +1. The time now is 02:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com