you can:
1. create a master file which opens each of the other files in a folder and
applies the macro

or

2. made an ad-in
--
Gary''s Student - gsnu200761


"Hassan" wrote:

Hi All,

Can I apply same macro on all files which are in one folder?

Kindly help.

Regards

Hassan