Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 - Macro Short Cut Key
I have created two Macros to update Workbooks. MonthlyUpdateCreditors
and MonthlyUpdateDebtors. Each has Ctrl+U as the Shortcut. Both work properly if Tools, Macro, Run is selected. The keyboard shortcut works with MonthlyUpdateCreditors bit not with MonthlyUpdateDebtors. Why might this be? TIA -- ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 - Macro Short Cut Key
Thanks Jim
That seems to have fixed it. -- Regards. Gerry ~~~~ FCA Stourport, England Enquire, plan and execute ~~~~~~~~~~~~~~~~~~~ Jim Jackson wrote: The shortcut will activate the first macro in the collection if it is assigned to more than one. Assign another letter to one of the macros or have the first one call the second upon completion. I have created two Macros to update Workbooks. MonthlyUpdateCreditors and MonthlyUpdateDebtors. Each has Ctrl+U as the Shortcut. Both work properly if Tools, Macro, Run is selected. The keyboard shortcut works with MonthlyUpdateCreditors bit not with MonthlyUpdateDebtors. Why might this be? TIA -- ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Short Macro | Excel Discussion (Misc queries) | |||
ZED - Need a short macro fix | Excel Discussion (Misc queries) | |||
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) | Excel Programming | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Macro short cut key | Excel Programming |