| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro shortcut help | Excel Worksheet Functions | |||
| Shortcut to a Macro | Excel Discussion (Misc queries) | |||
| Shortcut key to VB macro | Excel Discussion (Misc queries) | |||
| Macro: With Stop it works. Without Stop it doesn't. | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
