Code that executes against any Excel file

[Steve]

I was told the following scenario involving Excel ---

-----------
The code that executes is on my computer and it applies itself to the
workbook just downloaded.

I have my various "sort" macros as "all workbook" and I just click ALT-F7 or
Alt F8 which is my shortcut to them.
----------

Code in the first statement is the "sort" macros in the second statement.
Can someone explain what is happening here. Is there a way to put code in
Excel somewhere that will apply itself to any workbook that is opened? What
does it mean for the macros to be "all workbook"? Does ALT-F7 and Alt-F8
actually run code? How is this setup?

Thanks!

Steve

 

[cheesey_toastie]

I was told the following scenario involving Excel ---

-----------
The code that executes is on my computer and it applies itself to the
workbook just downloaded.

I have my various "sort" macros as "all workbook" and I just click ALT-F7 or
Alt F8 which is my shortcut to them.
----------

Code in the first statement is the "sort" macros in the second statement.
Can someone explain what is happening here. Is there a way to put code in
Excel somewhere that will apply itself to any workbook that is opened? What
does it mean for the macros to be "all workbook"? Does ALT-F7 and Alt-F8
actually run code? How is this setup?

Thanks!

Steve

I believe you can use a spreadsheet called Personal.xls. I've never
done this myself so you may need to do a little research.

Here are some urls with some info on how to do this.

http://www.personal-computer-tutor.com/personalxls.htm
http://en.allexperts.com/q/Excel-1059/Excel-Macros-9.htm