Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey all,
I'm using Excel 2003 and I'm unable to get my macro (with a hotkey assigned) to execute fully. Here's my macro which will stop after the 'open' command. It doesn't display the 2nd message box. Sub DoIt() MsgBox "Testing #1" Workbooks.Open ("C:\Testing.xls") MsgBox "Testing #2" End Sub I have this macro assigned to a hotkey (CTRL+SHIFT+D). It will execute as far as opening the workbook but then stop running. It won't execute anything after the Open command. If I put a break point on the first message box, it execute just fine (all the way through). If I create a toolbar and assigned a button on that toolbar to execute this macro, all is well --- just not through the hotkey. What am I doing wrong? Relvinian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
excel2007 hotkey | New Users to Excel | |||
Unable to add color to work sheet. | New Users to Excel | |||
Unable to get examples to work for lookup etc | Excel Worksheet Functions | |||
Hotkey problem w/ macro to append comment | Excel Discussion (Misc queries) |