Assigning a Function Key for a Weary Wrist

R

RalphSE

HI,

In a file that I use vrey regularly I am probably doing a certai
function 100 or more times a day and am too clueless to make a macr
for it and assign a hotkey. I would LOVE some help with this.

Here's what I am doing. I hit "Alt-E" then "D" then "U" then enter...
this basically just deletes the current cell and shifts the cells belo
it UP...

please, my hands will thank you, can we make it so all I have to do i
hit a function key and it will do this?

THANKS! :
 
R

Ron Coderre

Maybe you already know this.....

Pressing the [F4] key causes Excel to execute the last action.

[Alt]E D U [Enter]

Select the next cell to be deleted.
Press [F4] to repeat the "delete" action.
Repeat as necessary

Does that help?

Regards,
Ro
 
R

RalphSE

thanks Ron, I know about F4, its not really useful because I a
executing this command here and there, like 100 DIFFERENT times rathe
than 100 times in a row, etc..
 
R

RalphSE

Beege, if I knew how to do that without it taking me 2 hours of wrackin
my brain, I wouldn't be writing to this board, believe me, LOL
 
R

RalphSE

WOW!! I just pulled it off, it's working, but now every time I open th
file it asks me if I want to enable macros, isnt there a way to defaul
that to YES so it doesnt have to friggin ask me that every time
 
B

Beege

Ralph,

OK.

Select your Row
Tools/Macro/Record New Macro
Name your macro
Assign ctrl+key
OK
Right Click on selected row
Delete
Tools/Macro/Stop Recording

Test with assigned key
(always back uup your data first)

Beege
 
G

Guest

Ralph

Go to Tools/Macro/Record New Macro.
In the next dialog box, give the macro a key shortcut - one that you don't
already use (maybe k ) then click OK.
A small 'stop' button should appear. Ignore it for now and do your stuff
("Alt-E" then "D" then "U" then enter) and then click the stop button.
Job done.
Select your next cell, hit Ctrl+k and you're laughing!

Andy.
 
B

Beege

Ralph

Tools/Options/Security/Macro Security
Lookup Macro Security in the help file...

Beege
 
D

David McRitchie

Hi Ralph,
I don't really see the answer to your original question, and I don't think
you would record a macro with a line such as following..

Activecell.EntireRow.Delete

You could install an Event macro by right click on the worksheet tab
View code, and insert the following, applies only to the current sheet
http://www.mvps.org/dmcritchie/excel/event.htm
Event macros are installed differently than other macros.
The following would be invoked on a double click, very fast

Private Sub Worksheet_BeforeDoubleClick(ByVal Target _
As Range, Cancel As Boolean)
Cancel = True
Target.EntireRow.Delete
End Sub


You might also take a look at
http://www.mvps.org/dmcritchie/excel/delempty.htm
 
Top