LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Keyboard Macros

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find keyboard short-cut to type symbols on keyboard steamcomputerdriver Excel Discussion (Misc queries) 2 February 6th 10 01:58 PM
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros warning always shows up, even if all macros removed Joe M Excel Discussion (Misc queries) 1 December 20th 07 04:45 AM
Training: More on how to use macros in Excel: Recording Macros ToriT Excel Worksheet Functions 2 February 10th 06 07:05 PM
Keyboard Macros [email protected] Excel Programming 0 August 21st 03 12:42 AM


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"