Worksheet Function in a Module

[ijourneaux]

I would like to avoid placing a function in a worksheet but I have a couple of situations where I can't seem to get around it.

The first case is the Worksheet_FollowHyperLink function.

Please Login or Register  to view this content.

Another interesting thing here is that I had to Use

Please Login or Register  to view this content.

and could not use

Please Login or Register  to view this content.

The second case is where there is an object in the worksheet I need to access

Please Login or Register  to view this content.

In this case, I could refer to the object using

Please Login or Register  to view this content.

some times but I could not use it in the line where I set CurTag

Please Login or Register  to view this content.

did not work. If It had I would ahve been able to place the sub in a module

Apprecaite any comments or assistance.

Take Care

[romperstomper]

A worksheet event procedure has to go into the module for that sheet. No way round that, but you can move the actual processing code to a normal module and call that from the event.
For the rest, I can't think offhand of any reason why you would sometimes be able to use a given syntax and sometimes not.