Hi Del,
I have never heard of a way to run a macro through desktop shortcut, but maybe a google search would turn up something.
As to the e-mail, here is a great place to get some pre-built code http://www.rondebruin.nl/tips.htm
The macro basically uses a variable called LR to look for the last filled row in column A and when found, backs up one cell to insert a new row.
Bookmarks