I am trying to assign macro to a shape to open a hyperlink.

1st link (problem) This code works only :
Please Login or Register  to view this content.
if Cell A38 has value as a link (e.g."www.microsoft.com") but my value is derived from another cell (A1) that has function to fetch data from web and it's changing all the time. I've tried =hyperlink(A1), =TEXT(A1,1) and nothing.


2nd problem is that button/shape should start macro to open web page with inserted cell value (for instance : http://sec.gov/cgi-bin/browse-edgar?type=10-&dateb=&owner=include&count=40&action=getcompany&CIK="&Ticker&") where the Ticker is the cell value from another sheet that I am going to change regularly.

Thanks you so much, I was searching web for hours to find solution and didn't find anything that could help me.