Hi all,

HYCH with this,

Am wondering if there is a way to have a macro start recording when
information has been entered onto a sheet, maybe through a
worskeet_change event, that records the keystrokes of the user, so as
to look back should errors appear?


HYCH

Steve

It is possible to do this with VBA and keyboard APIs, but it is not easy.
--
Gary''s Student - gsnu2007b


"Steve" wrote:

Hi all,

HYCH with this,

Am wondering if there is a way to have a macro start recording when
information has been entered onto a sheet, maybe through a
worskeet_change event, that records the keystrokes of the user, so as
to look back should errors appear?


HYCH

Steve

On 4 Dec, 14:19, Gary''s Student
wrote:
It is possible to do this with VBA and keyboard APIs, but it is not easy.
--
Gary''s Student - gsnu2007b



"Steve" wrote:
Hi all,

HYCH with this,

Am wondering if there is a way to have a macro start recording when
information has been entered onto a sheet, maybe through a
worskeet_change event, that records the keystrokes of the user, so as
to look back should errors appear?

HYCH

Steve- Hide quoted text -

- Show quoted text -

Thanks Gary,

Was hoping it would be just a case of using VBa to have the Macro
record run whilst working


Steve

Hi Steve:

Checkout:

http://groups.google.com/group/micro...a59ddd47cc676f
--
Gary''s Student - gsnu200759


"Steve" wrote:

On 4 Dec, 14:19, Gary''s Student
wrote:
It is possible to do this with VBA and keyboard APIs, but it is not easy.
--
Gary''s Student - gsnu2007b



"Steve" wrote:
Hi all,

HYCH with this,

Am wondering if there is a way to have a macro start recording when
information has been entered onto a sheet, maybe through a
worskeet_change event, that records the keystrokes of the user, so as
to look back should errors appear?

HYCH

Steve- Hide quoted text -

- Show quoted text -

Thanks Gary,

Was hoping it would be just a case of using VBa to have the Macro
record run whilst working


Steve

On 4 Dec, 17:37, Gary''s Student
wrote:
Hi Steve:

Checkout:

http://groups.google.com/group/micro...rogramming/bro...
--
Gary''s Student - gsnu200759



"Steve" wrote:
On 4 Dec, 14:19, Gary''s Student
wrote:
It is possible to do this with VBA and keyboard APIs, but it is not easy.
--
Gary''s Student - gsnu2007b

"Steve" wrote:
Hi all,

HYCH with this,

Am wondering if there is a way to have a macro start recording when
information has been entered onto a sheet, maybe through a
worskeet_change event, that records the keystrokes of the user, so as
to look back should errors appear?

HYCH

Steve- Hide quoted text -

- Show quoted text -

Thanks Gary,

Was hoping it would be just a case of using VBa to have the Macro
record run whilst working

Steve- Hide quoted text -

- Show quoted text -

Thanks Again Gary,

was hoping to use something similar to the following to activate the
RECORD NEW MACRO option within the toolbars

Application.CommandBars("Worksheet menu
bar").Controls("Tools").Enabled = False

But thanks anyway