ExcelBanter - How to assign a macro to a key e.g. ctrl-S

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to assign a macro to a key e.g. ctrl-S (https://www.excelbanter.com/excel-programming/360733-how-assign-macro-key-e-g-ctrl-s.html)

MikeT

How to assign a macro to a key e.g. ctrl-S

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?

Gary''s Student

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?

MikeT

How to assign a macro to a key e.g. ctrl-S

Thanks.....

"Gary''s Student" wrote:

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?

All times are GMT +1. The time now is 01:51 PM.