No reason (that I know). I guess I just find it easier sometimes to put it in
code than to explain how to do it via the user interface.

David McRitchie wrote:

Hi Dave,
The reason for the largeness of the macro is for macro recording
to record what the macro did, plus the comments.

Is there a particular advantage of using of onkey over assigning
a shortcut to the macro. I have in the back of mind, don't know why,
that onkey was something to avoid unless you had to use it.
Is the advantage of onkey that it would not be in the toolbars file,
ease of use, or speed?
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
Maybe just assigning the macro to an .onkey procedu

Option Explicit
Sub auto_open()
Application.OnKey "^a", "myCtrlA"
End Sub
Sub auto_close()
Application.OnKey "^a"
End Sub
Sub myCtrlA()
Dim myCell As Range
Set myCell = ActiveCell
ActiveSheet.Cells.Select
myCell.Activate
End Sub


David McRitchie wrote:
Restore normal Ctrl+A before risking your data. Ctrl+A has always
meant one thing (Select everything) in all PC applications that have
any selection or editing ability. Excel 2003 has deviated from this
standard.
[clipped......]
The above have been included included on an Excel 2003 topic on my
Shortcut Keys in Excel
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar

--

Dave Peterson