Does anyone know why a code module inside a hidden worksheet stops
working after it's copied from one workbook to another?

I have a Worksheet_FollowHyperlink event that works until it gets
copied (the entire sheet is copied) from a hidden tab to an open
workbook. Afterwards, it no longer works. It never even runs (I set
breakpoints and/or used the Stop command). I then tried a
Worksheet_SelectionChange event, and got the same results. I'll also
mention that both workbooks are open together (the first being loaded
from within XLSTART). Could their be a conflict?


--
NamssoB
------------------------------------------------------------------------
NamssoB's Profile: http://www.excelforum.com/member.php...o&userid=26814
View this thread: http://www.excelforum.com/showthread...hreadid=400663