If you open a workbook with the shift key held down, then excel thinks you don't
want to run the auto_open or workbook_open procedures.

And since your shortcut key includes the shift key, it's confusing excel and
excel thinks you want to stop.

Remove the shift key from your shortcut key and try it out.

FYI: ctrl-z is the same as Edit|Undo. You may want to choose a different key.

Bob wrote:

I assigned Ctrl-Shift-Z to the macro below. When I execute the macro via
Tools | Macro | Macros... | Run, everything works fine. But if I execute the
macro via the keyboard shortcut, the macro inexplicably stops right after
line 7. Has anyone else run into this problem and/or can explain why it
happens? Please note that "Rates.xls" is open prior to running the macro.

Any help would be greatly appreciated. Thanks.

1 - Sub CleanUp()
2 - Application.ScreenUpdating = False
3 - Application.Calculation = xlCalculationAutomatic
4 - fname = ActiveWorkbook.Name
5 - pname = ActiveWorkbook.FullName
6 - spath = Left(pname, Len(pname) - Len(fname))
7 - Workbooks.Open Filename:=spath & "Taxes.xls"
8 - Workbooks("Rates.xls").Activate
9 - ActiveSheet.Rows("1:5").Delete Shift:=xlUp
10 - ActiveSheet.Rows("2:2").Delete Shift:=xlUp
11 - more code...
55 - End Sub

--

Dave Peterson