macro stop before end if I use a shortcut ?
 

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

macro stop before end if I use a shortcut ?
 

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

macro stop before end if I use a shortcut ?
 

thanks, it works without using the shift key. There are a lot of people which
will use my macro and want something different than just [Ctrl] + [letter].
Can I use something else ?

"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

macro stop before end if I use a shortcut ?
 

I don't think so.

Perhaps look at ONKEY in VBA help.

--
Regards,
Tom Ogilvy

"Alex St-Pierre" wrote in message
...
thanks, it works without using the shift key. There are a lot of people
which
will use my macro and want something different than just [Ctrl] +
[letter].
Can I use something else ?

"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

macro stop before end if I use a shortcut ?
 

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

macro stop before end if I use a shortcut ?
 

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

macro stop before end if I use a shortcut ?
 

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