thank Norman........this worked for me....

regards,
Amit

"Norman Jones" wrote:

Hi AtpGroups,

I suspect that it was your intention to respond
to Armit rather than to me.

Since, however you have appended your
response to my post, see my reply to Armit
and note thata CommandButton has an
Accelerator property.




---
Regards.
Norman


"atpgroups" wrote in message
...
On 10 May, 09:50, amit wrote:
hi - I've got a userfomr that has a "Save & Close" command button which
saves
the user entry back to a database.....is ther a way to invoke the command
button by using ctrl + s

See http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

You need a line somewhere whch says
Application.Onkey "^s", "MySaveCloseRoutine"

Either put in in the form_activate event code and then disable it
again in form_deactivate if you only want it to be active with the
form open, or put it in Workbook_Open and deactivate in
Workbook_BeforeClose if you want it to work all the time.

I have a (stupidly) huge VBA Macro which has subverted all the Excel
menu commands and keyboard shortcuts in this way so that users can
exchange data files without sending out a copy of the macro/
application with each one. This sounds not dissimilar to what you are
trying to do.