Macros

  • Thread starter Thread starter Lord Of The Morning
  • Start date Start date
L

Lord Of The Morning

Does anyone know why when after I typed information into a cell and click on
a macro the macro will not function unless after I typed the information
into the cell I click enter or tab out of the cell then the macro becomes
active.
Is this just something I have to deal with?

Nick
 
Macros do not work when in edit mode, which is the mode you describe.
Entering or Tabbing takes you out of edit mode and your macro can now operate.

Gord Dibben Excel MVP XL2002
 
Back
Top