Hyperlinks and Comments
 

I am new to Macros (know how to cut/paste into Macro module) but need
assistance for a project that is due this afternoon/tomorrow morning.

I have a description listing that will reside on our Intranet site. Entire
worksheet is Read-only; comments should be viewable if cell selected. Each
product should link to a seperate document based on Category type. How can I
add a hyperlink to each description (w/o CTRL+K individual description) based
on the Category? Also my comments continue to resize and are not visible, is
there a way to prevent this from happening?

Any assitance is greatly appreciated.