ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating shortcut keys (https://www.excelbanter.com/excel-discussion-misc-queries/4360-creating-shortcut-keys.html)

Magnus Ramfelt via OfficeKB.com

Creating shortcut keys
 
Hallo, does anyone know how to create a shortcut keys in general for excel. Sure you can record a macro for whatever you need to do but then you can't undo. If you decide to run a macro however, does anyone know if you can tell it to increase decimals? I tried to record a macro just clicking on that button but it doesn't work.

Thanks for your help on this, any suggestions are great.

--
Message posted via http://www.officekb.com

Jim Rech

does anyone know how to create a shortcut keys in general for excel.

There are two way. You can create assign a shortcut key by VBA code using
the OnKeys method. And through the user interface you can use Tools, Macro,
Macros, select the macro name, and click Options.

--
Jim Rech
Excel MVP
"Magnus Ramfelt via OfficeKB.com" wrote in message
...
| Hallo, does anyone know how to create a shortcut keys in general for
excel. Sure you can record a macro for whatever you need to do but then you
can't undo. If you decide to run a macro however, does anyone know if you
can tell it to increase decimals? I tried to record a macro just clicking on
that button but it doesn't work.
|
| Thanks for your help on this, any suggestions are great.
|
| --
| Message posted via http://www.officekb.com




All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com