Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how to make a macro and run in every excel book that opened?

  Asked By: Loretta    Date: Oct 29    Category: MS Office    Views: 680
  

I make a macro and assigned that macro to customized menu bar.

Seems that macro doesn't run in other book.

Somebody know how to make a macro and run in every excel book that opened?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Lucio Ferrrari     Answered On: Oct 29

You should save the macro  in the personal.xls file (the location of this
personal XLS file is C:\Documents and Settings\pc\Application
Data\Microsoft\Excel\XLInicio)

 




Tagged: