Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Problem as stated Above
Discovered when I recreated, from scratch,
all macros and source files, on another computer.
It locked up as before on my main computer.
By chance I tried Macro RUN, and lo an behold, it worked.
I have previously submitted a macro for the same process, but
operating differently. It also locked up after file 1.xls was
opened and would just sit there with active cell A1.

SO, how and/or why, can/does a keyboard shortcut
stop a macro from running

Sub Create_MASTER_File()
' KeyBoard ShortCut: Ctrl+Shift+ M
' ToolBar Icon: NONE
' Menu Item: NONE

Dim DestBook As Workbook
Dim mySource As Workbook
Application.ScreenUpdating = False
Application.EnableEvents = False

' Open Workbook and Save As: M2M-MASTER.XLS
Workbooks.Add
ChDir "C:\DATA"
ActiveWorkbook.SaveAs Filename:="C:\DATA\M2M-MASTER.XLS",
FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

' The M2M-MASTER must be (will be) the active WB when initiating macro
Set DestBook = ActiveWorkbook
Sheets(1).Activate
Set mySource = Workbooks.Open("C:\DATA\1.xls")

' 1.xls is now open and available
' Go to 1.xls, Sheet #1, Row 1, Copy
' Go to DestBook, Sheet 1, Row 1 and Insert Cut Cells

DestBook.Worksheets(1).Range("A1:IV1").Value =
mySource.Worksheets(1).Range("A1:IV1").Value

' Save only DestBook
With DestBook
.Save
End With

'Save and Close Source Book.xls
With mySource
.Save
.Close Savechanges:=True
End With

Application.EnableEvents = True
Application.ScreenUpdating = True

End Sub

.

Relevant Pages

  • Re: Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up
    ... Dave, as you explained, removing the 'Shift' worked bang on. ... By chance I tried Macro RUN, and lo an behold, it worked. ... Dim DestBook As Workbook ...
    (microsoft.public.excel.programming)
  • [NT] Cumulative Patches for Excel and Word for Windows
    ... The attacker's macro code could take any actions on the system ... * An Excel macro execution vulnerability that relates to how inline ... * An Excel macro execution vulnerability that relates to how macros are ... It is possible for macros in a workbook so invoked to run ...
    (Securiteam)
  • RE: Activating a renamed workbook
    ... The go to tab Commands and select Macro. ... my programming experience in Outlook is very poor so please help me out. ... Then I can have a procedure in the main Excel application installing the ... because it activates the workbook always having the same name! ...
    (microsoft.public.excel.programming)
  • Re: Cannot Utilize a Macro When Excel Is Opened By Another Program
    ... MST must be starting Excel in safe modewhich by-passes XLSTART folder. ... Run Macro, Break, Reset or Design Mode. ... i.e. the workbook just created. ... Perhaps due to the method that MST creates a new workbook and opens ...
    (microsoft.public.excel)
  • Re: Cannot Utilize a Macro When Excel Is Opened By Another Program
    ... MST must be starting Excel in safe modewhich by-passes XLSTART ... Run Macro, Break, Reset or Design Mode. ... i.e. the workbook just created. ...
    (microsoft.public.excel)