View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How to assign a macro to a key e.g. ctrl-S

In the worksheet, pull-down:

Tools Macro Macros Options

then enter a short-cut-key


--
Gary''s Student


"MikeT" wrote:

I have a macro that does a "paste-special, transpose" and I would like to
assign this action to a keypress. How is that done?