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
~~~~~~~~~~~~~~~~~

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
~~~~~~~~~~~~~~~~~