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