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

On 16 Aug, 02:26, "Steve" <so...@private.emailaddress> wrote:
> 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-105...l-Macros-9.htm