You are undoubtedly right but I never thought of that. I use the shift key
all the time in Access to keep maros from executing on start up. I will have
to try the onkey thing some time just to confirm.

Thanks for the reply...

"Tom Ogilvy" wrote:

I doubt that setting the same combination in OnKey would make a difference -
the problem is that holding down the shift key when opening a workbook
suppresses the Auto_Open and Workbook_Open macros, so holding it down for
the shortcut key combination has the same effect. OnKey wouldn't change
that.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
Tom how do you know these things? One question... Is there a way around
this
setting the

application.onkey

Wondering if you know...

"Tom Ogilvy" wrote:

You are using a shortcut key combination that includes the shift key.
Change the combination to something that does not include the shift key.

--
Regards,
Tom Ogilvy

"Alex St-Pierre" wrote in
message
...
Hello,
My macro run completly if I do manually Macro/Execute
If I execute the keyboard shortcut, the macro stop after the line:
Workbooks.Open "C:\temp.dbf"
Does anyone have an idea ?
Thanks !
--
Alex St-Pierre