stop autoexec

[rojdhi]

Hi.
I have a macro that works at the opening of my report.

How open the report without executing the macro...?? (just like Shift + open with Access...)

Thx.

 

[promero]

Try this:
[tt]
Private Declare Function GetAsyncKeyState _
Lib "USER32" (ByVal vVey As Long) As Integer

Private Sub Document_Open()
If GetAsyncKeyState(vbKeyShift) < 0 Then Exit Sub
MsgBox &quot;Hello!&quot;
End Sub
[/tt]