Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get macro hotkey to work
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get macro hotkey to work
If you use Shift as part of the hotkey, then use a hotkey that does not
include shift. -- Regards, Tom Ogilvy "Relvinian" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |