Hi ManDeep

Save your routines in a personnal macros workbook (PERSONNAL.XLS) and place
this workbook in the xlStart folder on your computer.
Or: just start recording a new dummy macro and from the record dialog box
select to record it into a personnal macros workbook, validate and then stop
recording.
You will then be able to copy your macros from the original workbook into
the newly created workbook which will only be visible from the VB Editor.

HTH
Cordially
Pascal


"Mandeep Dhami" a écrit dans le
message de news: ...
Hi,

I have created few macros to prepare Pivot Table through Record Macro
function.

I want that these macros I should able to run every month in different
files. Name of the files will be different.

What can I do to make these macros perform every month for different
files.

Cheers,
Mandeep