Worksheet_FollowHyperlink
 

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? :mad:


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

Worksheet_FollowHyperlink
 

How are you copying that hidden worksheet?

When I copy hidden worksheets, I have to unhide them, copy, and rehide the
original worksheet (and maybe hide that copy).

When I did this, the worksheet_followhyperlink worked fine.

And how would you use any of these events when they're associated with a hidden
sheet?

NamssoB wrote:

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? :mad:

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

--

Dave Peterson