Running code from ~? Don't want to use <Ctrl<key
 

Hi,

I am fairly fluent in VBA for Access, but have next to no experience
with Excel. I am doing this for a friend...

He wants to be able to delete an entire row with one keystroke, in
this case, the ~. He doesn't want to use <Ctrl<q or
<Ctrl<anything. Just one key! I have the code to delete the row,
but how do I assign that to just one key?

Many thanks!

Patti

Running code from ~? Don't want to use <Ctrl<key
 

Patti,

I think you could use the OnKey method in the WorkBook Open and BeforeClose
events to assign and unassign a delete macro to that key, but I'm not sure.

hth,

Doug

"Patti" wrote in message
om...
Hi,

I am fairly fluent in VBA for Access, but have next to no experience
with Excel. I am doing this for a friend...

He wants to be able to delete an entire row with one keystroke, in
this case, the ~. He doesn't want to use <Ctrl<q or
<Ctrl<anything. Just one key! I have the code to delete the row,
but how do I assign that to just one key?

Many thanks!

Patti