Event Macro - Hyperlink selected
 

Hi,

I have 2 sheets; 1 = database, 2 = Look up sheet

Ea Value Column B Sheet 1 is hyperlinked to Sheet 2.
When user selects the hyperlinked cell the value of cell selected auto
populates
cell A9 Sheet 2. Once populated cell A9 Sheet 2 is the match value of index
formulas in cells E10, A11, E11, A13, E13, A15, C15, E15, & G15.
The Look up sheet body then is ready to be emailed internally within the
office

My problem is that these formulas are subject to mistaken
deletion/alteration if left un-protected but you can't email as body a
protected sheet.

I believe an event macro in Sheet 2 that copies the match value in Sheet 1,
BA1
is the route to go but I'm not versed in writing code. If any assistance
can be provided to help with this task would be most appreciative. Thx !!!