CorelDraw VBA - Events ------ Problems with hyperlinks in excel

[Malik641]

Hi everyone,

This seems so easy, but I can't figure out what's going on.

In my gms (Global Macro Storage) file, I placed the following code in the "ThisMacroStorage" class.

Option Explicit

Private Sub GlobalMacroStorage_DocumentOpen(ByVal Doc As Document, ByVal FileName As String)
' Check the border and fix the address if need be
    Call FixAddress
End Sub

Now at first I couldn't get the event to fire when opening a drawing (creating the instance of the CorelDraw application). I found an option "Delay Load VBA" that needed to be checked off. After that when I open files it fires the events, which is perfect.

But I have a spreadsheet in Excel that has hyperlinks of my cdr (CorelDraw) files. When I open the drawings from the hyperlinks it will not fire the event. Why?

Thanks in advance