Command Button Hyperlink Code

[dparteka]

I appreciate any help with this; it's my second round attempt to seek a solution... I’m using XP and Excel 2003


In cell B5 is this text... HublicEngineeringCustomer's FilesSiemens EnergyDocument LinksP0001813700 DocLink.xls


In cell C5 is... =HYPERLINK(B5)


If I click cell C5 it hyperlinks to the document specified in cell B5


I want to use a Control Toolbox Command Button that is on the spreadsheet to trigger the hyperlink in C5, can you tell me what the code would be?


NOTE: The path in B5 changes from spreadsheet to spreadsheet so it can not be part of the code.

 

[bobhc]

@ dparteka


This is the same post as http://chandoo.org/forums/topic/command-button-code


Double posting is frowned on, you insult those that have already answered by basically saying you do not like/understand/want/bothered by those that have helped, I believe SirJB7 pointed you in the right direction, if you still have a problem you should ask for further help or clarification in your original question post. This way the question does not get messy and others who may have a similar problem and are following the OP will not loose the thread and possible answer