How to run one macro in all the excel files
 

Hi................

I have created a macro and want to run that macro in all the excel
files.
But to that I have to open the file that contain the macro every now
and
then I want to avoide that.

Is there any way to do that....................

Regards,

Kashif Khan

How to run one macro in all the excel files
 

select 'This Workbook' while creating the macro.

wrote in message
oups.com...
Hi................

I have created a macro and want to run that macro in all the excel
files.
But to that I have to open the file that contain the macro every now
and
then I want to avoide that.

Is there any way to do that....................

Regards,

Kashif Khan

How to run one macro in all the excel files
 

Put it in your personal.xls file.

windows unhide and there should be a personal.xls file.

if not run the macro recorder and save a dummy macro in the personal macro
file.

Then go to the editor and open the personal macro file and put the code in
there.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


" wrote:

Hi................

I have created a macro and want to run that macro in all the excel
files.
But to that I have to open the file that contain the macro every now
and
then I want to avoide that.

Is there any way to do that....................

Regards,

Kashif Khan