macro to record keystrokes ?

[Steve]

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

 

[Gary''s Student]

It is possible to do this with VBA and keyboard APIs, but it is not easy.

 

[Steve]

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







- 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

 

[Gary''s Student]

Hi Steve:

Checkout:

http://groups.google.com/group/micr...'s+Student+api++group:*Excel#68a59ddd47cc676f

 

[Steve]

Hi Steve:

Checkout:

http://groups.google.com/group/microsoft.public.excel.programming/bro...
--
Gary''s Student - gsnu200759








- 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