Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What's the best way to set the following keystrokes up as a
keyboard macro? F2, CTRL+A, F4, [Enter] I keep wanting real keyboard macros but for some reason, the recording of these keypresses doesn't work. F2 doesn't get recorded, the cell contents gets recorded (and that's not any part of the keystroke sequence), F4 doesn't get recorded even though F4 forces the cell into an Absolute Reference, CTRL+A isn't recorded. I'm using Excel XP. I keep thinking that I'm going to have to use SendKeys, but this is getting way to complicated to do something that is a basic component of DOS spreadsheets and advanced DOS code editors. I must have overlooked something somewhere. I'm not sure what a Macro after trying to do this. ;-) -- Jim Carlock http://www.microcosmotalk.com Feel free to post back to the newsgroup! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find keyboard short-cut to type symbols on keyboard | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Keyboard Macros | Excel Programming |