View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_91_] Steve[_91_] is offline
external usenet poster
 
Posts: 27
Default Code that executes against any Excel file

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