View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aine_canby@yahoo.com is offline
external usenet poster
 
Posts: 11
Default Application level VBE

Hi,

I wish to use VBE to process all the ducuments currently open in excel.
What kind of object do I associate this code with? For example, a macro
is used to associate vbe with a document and a key shortcut can be
issued to trigger this macro if this doc has focus (is the active
ducument). Also, this vbe code resides with the document in question.
Instead, I want a button or something in excel which I can press to
process my files. I also want to be able to send this button object to
a client so that they can install it in there version of Excel. How do
I do this?

Thanks,

Aine.