Hi All.......

XL07......having trouble getting this to fire......

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
MsgBox " this is it"
Call MyMacro
End Sub

Same with the same function in the Workbook

Any idea what I might be doing wrong?

Hi,

Works fine for me. You have to have it as worksheet code as opposed to in a 
general module.

Mike

"CLR" wrote:

> Hi All.......
> 
> XL07......having trouble getting this to fire......
> 
> Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> MsgBox " this is it"
> Call MyMacro
> End Sub
> 
> Same with the same function in the Workbook
> 
> Any idea what I might be doing wrong?

Hi Mike......
Thanks for the comeback.  I understand that it's worksheet code, in this 
instance and workbook code when I try it there, but neither seem to fire.  
The Hyperlink I'm using opens another file, then I want to run a macro 
located in the original file against that newly opened file.  But NOTHING 
happens....I don't even get the msgbox popup.

My Hyperlink was created by recording a macro and editing it, rather than 
using original code.....it that makes a difference.

Might I have some Excel setting set wrong?

Vaya con Dios,
Chuck, CABGx3



"Mike H" wrote:

> Hi,
> 
> Works fine for me. You have to have it as worksheet code as opposed to in a 
> general module.
> 
> Mike
> 
> "CLR" wrote:
> 
> > Hi All.......
> > 
> > XL07......having trouble getting this to fire......
> > 
> > Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> > MsgBox " this is it"
> > Call MyMacro
> > End Sub
> > 
> > Same with the same function in the Workbook
> > 
> > Any idea what I might be doing wrong?

Actually, now that I've checked.....NONE of my event macros are working in 
07.  I even opened another file with event macros in it that I wrote in xl2k 
and none of them will fire either.........could it be a bad install of 07, or 
just some switch set wrong?

Vaya con Dios,
Chuck, CABGx3





"Mike H" wrote:

> Hi,
> 
> Works fine for me. You have to have it as worksheet code as opposed to in a 
> general module.
> 
> Mike
> 
> "CLR" wrote:
> 
> > Hi All.......
> > 
> > XL07......having trouble getting this to fire......
> > 
> > Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> > MsgBox " this is it"
> > Call MyMacro
> > End Sub
> > 
> > Same with the same function in the Workbook
> > 
> > Any idea what I might be doing wrong?

--Check whether macros are enabled

--Did you disable the events through code...In immediate window type the 
below and hit enter..then check whether events are getting fired 

Application.EnableEvents = True 

-- 
Jacob


"CLR" wrote:

> Hi All.......
> 
> XL07......having trouble getting this to fire......
> 
> Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> MsgBox " this is it"
> Call MyMacro
> End Sub
> 
> Same with the same function in the Workbook
> 
> Any idea what I might be doing wrong?

Look at your security settings, see "Change macro security settings in 
Excel" in help.

For new or non xls or xla files be sure to save as .xlsm or .xlam

Regards,
Peter T

"CLR" <CLR@discussions.microsoft.com> wrote in message 
news:A493A8FA-8EB5-44D6-BE94-E0E2E4CC86E5@microsoft.com...
> Actually, now that I've checked.....NONE of my event macros are working in
> 07.  I even opened another file with event macros in it that I wrote in 
> xl2k
> and none of them will fire either.........could it be a bad install of 07, 
> or
> just some switch set wrong?
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
>
> "Mike H" wrote:
>
>> Hi,
>>
>> Works fine for me. You have to have it as worksheet code as opposed to in 
>> a
>> general module.
>>
>> Mike
>>
>> "CLR" wrote:
>>
>> > Hi All.......
>> >
>> > XL07......having trouble getting this to fire......
>> >
>> > Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
>> > MsgBox " this is it"
>> > Call MyMacro
>> > End Sub
>> >
>> > Same with the same function in the Workbook
>> >
>> > Any idea what I might be doing wrong? 

That did the trick Jacob...........many thanks

<mumble>, so simple, why didn't I think of that? <mumble, mumble>

Vaya con Dios,
Chuck, CABGx3




"Jacob Skaria" wrote:

> --Check whether macros are enabled
> 
> --Did you disable the events through code...In immediate window type the 
> below and hit enter..then check whether events are getting fired 
> 
> Application.EnableEvents = True 
> 
> -- 
> Jacob
> 
> 
> "CLR" wrote:
> 
> > Hi All.......
> > 
> > XL07......having trouble getting this to fire......
> > 
> > Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
> > MsgBox " this is it"
> > Call MyMacro
> > End Sub
> > 
> > Same with the same function in the Workbook
> > 
> > Any idea what I might be doing wrong?